March 31 - April 2, 2025, in Las Vegas, Nevada. Use code MSCUST for a $150 discount! Early bird discount ends December 31.
Register NowBe one of the first to start using Fabric Databases. View on-demand sessions with database experts and the Microsoft product team to learn just how easy it is to get started. Watch now
Hi,
I want to create a slicer that can change the graphs displayed (all within the same space for one graph).
I succeeded in creating a slicer that displays one graph at a time that changes upon my selection in the slicer.
However, the item that does not work yet is: I want to be able to use multiple selections in the slicer and then show multiple graphs displayed in the same place.
I am currently using the following:
1) I created a table named "Select" with:
Select Order
Value 1 1
Value 2 2
Value 3 3
2) The following measure
Measure Select = SWITCH(SELECTEDVALUE('Select'[Select]),
"Value1",[Value1],
"Value2",[Value2],
"Value3",[Value3])
This only displays one graph at a time and when I make multiple selections at the same time in the slicer, then there is no graph displayed.
Which changes do I need to make in my measure to be able to see multiple graphs at the same time when clicking on multiple selections in the slicer?
Thank you for the help,
Solved! Go to Solution.
@Anonymous , If you want to hide and show visual you have to use bookmarks
https://radacad.com/bookmarks-and-buttons-making-power-bi-charts-even-more-interactive
https://docs.microsoft.com/en-us/power-bi/desktop-bookmarks
If you want to make a dynamic axis or measure , you need field parameters
@Anonymous , If you want to hide and show visual you have to use bookmarks
https://radacad.com/bookmarks-and-buttons-making-power-bi-charts-even-more-interactive
https://docs.microsoft.com/en-us/power-bi/desktop-bookmarks
If you want to make a dynamic axis or measure , you need field parameters
Solved it through the field parameters (second link). Thank you!
March 31 - April 2, 2025, in Las Vegas, Nevada. Use code MSCUST for a $150 discount!
Your insights matter. That’s why we created a quick survey to learn about your experience finding answers to technical questions.
Arun Ulag shares exciting details about the Microsoft Fabric Conference 2025, which will be held in Las Vegas, NV.
User | Count |
---|---|
129 | |
90 | |
75 | |
58 | |
53 |
User | Count |
---|---|
200 | |
104 | |
101 | |
67 | |
55 |