Forum Discussion
Advanced Slicer Groups - Single Data Source, synchronized unrelated Slicers.
It might be a little annoying to do, but if you are looking to have titles change dynamically on what you select from your slicer. You could add some logic to the titles using IF(), SELECTEDVALUE(), or SWITCH().
Something like:
YourDynamicTitle=
SWITCH (
TRUE (),
SELECTEDVALUE('Table'[Column]) = "UnitedStates", "USD",
SELECTEDVALUE('Table'[Column]) = "Canada", "CAD",
SELECTEDVALUE('Table'[Column]) = "Mexico", "MXN",
"Default Result"
)
Or even:
IF( SELECTEDVALUE('Table'[Column]) = 'United States', 'Sales for United States, IF(.....Im not going to type it all out but basically you would need to nest a bunch of IFs inside each other to handle all the scenarios of what you want to be displayed in your Title card based off of the slicer selection.
If this helps you out please consider marking it as the solution.👍
Thanks for your reponse, CalebR!
I implemented the concept of creating a separate table and using it as a slicer in my Power BI report. I then created two measures that depend on the selected value from the slicer.
The concept works perfectly, and I'm getting the correct values. However, I've encountered an issue with the titles not being dynamic.
While it's not an ideal situation, for now, the solution I see is to replicate the same chart and use bookmarks to control which chart is displayed based on the user's selection.
I'm currently transitioning from Tableau to Power BI, and my Tableau dashboards frequently utilize this concept. I'm somewhat surprised to find that there isn't a direct one-to-one mapping of this logic in Power BI.
It might be a little annoying to do, but if you are looking to have titles change dynamically on what you select from your slicer. You could add some logic to the titles using IF(), SELECTEDVALUE(), or SWITCH().
Something like:
YourDynamicTitle=
SWITCH (
TRUE (),
SELECTEDVALUE('Table'[Column]) = "UnitedStates", "USD",
SELECTEDVALUE('Table'[Column]) = "Canada", "CAD",
SELECTEDVALUE('Table'[Column]) = "Mexico", "MXN",
"Default Result"
)
Or even:
IF( SELECTEDVALUE('Table'[Column]) = 'United States', 'Sales for United States, IF(.....
Im not going to type it all out but basically you would need to nest a bunch of IFs inside each other to handle all the scenarios of what you want to be displayed in your Title card based off of the slicer selection.
If this helps you out please consider marking it as the solution.👍
I also just realized you may be talking about the titles of the visuals themselves. In that case you should be able to go into General settings on the visual, expand the Title section, and hit the fx button. That will allow you to select a measure to dynamically update the title.