Forum Discussion
Helper IUsing what-if parameters (instead of bookmarks)
Hi all,
hope all of you are doing fine 🙂 I have been working with PBI for some time and also some tasks with what of parameters, but only used what-if parameters in very simple examples. Now I would like to use parameter instead of my bookmarks..
So for now I have report looking something like this:
So I have a bar chart and on the left I have three bookmarks depending on what should be in the legend of the bar chart. So for example when I have selected Split by name: a bar chart which has in the legend a column "name". When I click on split by month the legend will be based on the column "Month" etc...
However, as I have also some other bookmarks in my original repor, it creats a bit confusing look, so I would like to create this possibility with what if parameter:
Instead of the bookmarks I would like to have a slicer that is offering these 3 options. These 3 field are original variables from my dataset (so no calculated columns).
So what I have done so far is I created a parameter:
In general, to use a measure in that way, you need to use the Disconnected Table Trick as this article demonstrates: https://community.powerbi.com/t5/Community-Blog/Solving-Attendance-with-the-Disconnected-Table-Trick/ba-p/279563
4 Replies
- Greg_Deckler
Community Champion
In general, to use a measure in that way, you need to use the Disconnected Table Trick as this article demonstrates: https://community.powerbi.com/t5/Community-Blog/Solving-Attendance-with-the-Disconnected-Table-Trick/ba-p/279563
AU555Greg_Deckler Thanks!
- Greg_Deckler
It's really hard to be specific without sample data. Please see this post regarding How to Get Your Question Answered Quickly: https://community.powerbi.com/t5/Community-Blog/How-to-Get-Your-Question-Answered-Quickly/ba-p/38490.
It sounded like you wanted to change up your axis based on a measure which generally leads down the disconnected table trick route.