Forum Discussion
HSpeelman
4 years agoFrequent Visitor
Show additional measures in same visual based on selected value in the slicer
Hi,
I have following case for my client:
- Problem:
- User wants to select one value in a slicer ('net sales' or 'costs')
- When 'net sales' is selected, a table needs to be shown with 4 columns: 'category', 'net sales', 'previous year net sales', 'net sales budget'
- When 'costs' is selected, a table needs to be shown with 3 columns: 'category', 'costs', 'previous year costs'
I am not sure if it is possible to have this kind of mechanic in Power BI.
I currently fixed it with having a visual filter on two separate visuals, where DAX detects which value is selected in the slicer and based on that, the visual A or B is shown. However, this implies that two visuals need to be maintained and tooltips won't work for one of the visuals as they are placed on top of each other.
So I wanted to check if it is possible to have this kind of mechanic in one visual.
1 Reply
- PaulDBrownCommunity Champion
You can achive this using bookmarks.
https://docs.microsoft.com/en-gb/power-bi/create-reports/desktop-bookmarks