Forum Discussion
Single toggle button to change visuals on all pages
Hi,
Seeking to see if any user had success in creating a single toggle button on main page to change visual colours to apply across all pages eg. change a blue visual to red visual on page 1 and sync the same colour change to page 2, page 3 etc. I did try bookmark but did not get it to work as the button could not be synced like slicers. Unless I am missing some steps. Any help or suggesstions would be much appreciated. Thanks
This is what I meant with controlling the colors with slicers - Power BI accepts RGB, RGBA, hex and some color names. Again, conditional formatting isn't supported for legends. Slicers also cannot trigger bookmarks
Please see the attached pbix.
Hi powerbitogo,
The reason you can’t apply the slicer-based color toggle to your charts is because only certain visual properties in Power BI support conditional formatting. The toggle works when you see the fx option next to settings like Data Colors, Title, or Background. If your visual doesn’t have this fx button for Data Colors, dynamic color changes aren’t possible due to current product limitations. Legend colors also can’t be changed dynamically, even if you create the legend manually with shapes. To use the toggle, you need a measure that returns the selected Hex/RGB value from the slicer and apply it to visual elements that support conditional formatting.
Thasnk you.
15 Replies
- danextian
Super User
Hi powerbitogo
If you want to apply the change of color to all pages then bookmark isn't the right approach as, at most, it affects only a single page. You can instad use conditional formatting controlled by a slicer that is synched across different pages. One limitation to bear in mind is conditional formatting is not supported on legends.
The legends are created separately from the visuals ie. they are shapes with labels. Would that work? Thanks
- danextian
I was referring to the legend color. They can't be conditionally formatted so even if you follow a slicer approach, you won't be able to change the color of the legends dynamically.
- GeraldGEmerick
Memorable Member
powerbitogo I would need some additional information but it occurs to me that you could use something like a slicer (in Tile mode for example) and then use conditional formatting based on a measure that is based upon what is selected in the slicer. More details would help me make this more specific to your needs.
Hi Gerald,
Thanks for your quick response.
This is what I am trying to achieve. Have a single toggle on page 1 where I can change the colour of the visuals from colour A to colour B and to apply across multiple pages with visuals. Please let me know if you need more details. Thanks
ExcelMonkeImpactful Individual
I concur with danextian 's approach here. Based on your description, you can consider syncing this slicer across pages (you can use the option to hide).
But let us know if this is not the intended behaviour you're expecting.Basically, I had the colours into two groups. ie. Group A with a list of colour A visuals on all pages and Group B with a list of colour B visuals on all pages. I then linked it as a bookmark. However, it is not possible to bookmark as a group but indiviually. Thanks
This what I meant by the two groups.
I don't mind hiding the slicers in the other pages. I just need the slicer to be on page 1 and when I select either colour A or colour B in page 1 to change the visuals in page 1 and to apply the same change across all pages. Thanks
- danextian
This is what I meant with controlling the colors with slicers - Power BI accepts RGB, RGBA, hex and some color names. Again, conditional formatting isn't supported for legends. Slicers also cannot trigger bookmarks
Please see the attached pbix.
- v-sgandrathi
Community Support
Hi powerbitogo,
The reason you can’t apply the slicer-based color toggle to your charts is because only certain visual properties in Power BI support conditional formatting. The toggle works when you see the fx option next to settings like Data Colors, Title, or Background. If your visual doesn’t have this fx button for Data Colors, dynamic color changes aren’t possible due to current product limitations. Legend colors also can’t be changed dynamically, even if you create the legend manually with shapes. To use the toggle, you need a measure that returns the selected Hex/RGB value from the slicer and apply it to visual elements that support conditional formatting.
Thasnk you.
- v-sgandrathi
Hi powerbitogo,
Just wanted to follow up and confirm that everything has been going well on this. Please let me know if there’s anything from our end.
Please feel free to reach out Microsoft fabric community forum.Thank you.
- v-sgandrathi
Hi powerbitogo,
Just looping back one last time to check if everything's good on your end. Let me know if you need any final support happy to assist if anything’s still open.
Thank you.
