The ultimate Fabric, Power BI, SQL, and AI community-led learning event. Save €200 with code FABCOMM.
Get registeredCompete to become Power BI Data Viz World Champion! First round ends August 18th. Get started.
Hello, i would like to create the following clear all slicer button..
If there are no slicers active in my report, the button looks like:
If there are slicers active, my button looks like this:
Preferably also my selection box would be blue instead of black:
Does anyone know how to reach this effect? I used the (old) Slicer visual and the 'clear all filter' button. I feel like its not possible as there is no style>'disabled' option for the clear all filter button?
Thankyou!
Solved! Go to Solution.
Hi @Clau90
Insert a Shape
Add Text "Clear Filter"
Create a DAX measure (as per the column you are using in the slicer)
Measure = IF(
ISFILTERED('table'[Year]),
"BLUE","GRAY")
Go to Shape background FX logic and use the measure as Field Value
Select the slicer and you can use button color change from GRAY to BLUE
As per my knowledge, you cant change black selected item to blue.
If your requirement is solved, please make sure to MARK AS SOLUTION and help other users find the solution quickly. Please hit the LIKE button if this comment helps you.
Thanks
Pijush
www.MyAccountingTricks.com
https://www.youtube.com/MyAccountingTricks
Proud to be a Super User! | |
Hi @Clau90
Insert a Shape
Add Text "Clear Filter"
Create a DAX measure (as per the column you are using in the slicer)
Measure = IF(
ISFILTERED('table'[Year]),
"BLUE","GRAY")
Go to Shape background FX logic and use the measure as Field Value
Select the slicer and you can use button color change from GRAY to BLUE
As per my knowledge, you cant change black selected item to blue.
If your requirement is solved, please make sure to MARK AS SOLUTION and help other users find the solution quickly. Please hit the LIKE button if this comment helps you.
Thanks
Pijush
www.MyAccountingTricks.com
https://www.youtube.com/MyAccountingTricks
Proud to be a Super User! | |