Forum Discussion
bhartisharma_in
1 year agoFrequent Visitor
Issue with DAX Measure for Slicer Header Color Change
Hi everyone, I’m facing an issue with applying a DAX measure to change the color of a slicer header in Power BI. Here’s the DAX measure I’m using: color change = IF(ISFILTERED(Product[Category]), ...
- 1 year ago
Slicer headers in Power BI currently do not support dynamic formatting through DAX measures. This feature works for visuals like text boxes but not slicer headers.
Workaround:
- Instead of changing the slicer header color, use a card visual or text box to display a dynamic label or message styled using your DAX measure.
- Place the styled visual near the slicer for the desired effect.
This is a limitation of Power BI's current functionality.
rohit1991
1 year agoSuper User
Slicer headers in Power BI currently do not support dynamic formatting through DAX measures. This feature works for visuals like text boxes but not slicer headers.
Workaround:
- Instead of changing the slicer header color, use a card visual or text box to display a dynamic label or message styled using your DAX measure.
- Place the styled visual near the slicer for the desired effect.
This is a limitation of Power BI's current functionality.
- bhartisharma_in1 year agoFrequent Visitor
Thanks for the tip!
I’m using this workaround too, and it’s working great for me. Hopefully, Power BI will support dynamic formatting for slicer headers soon. 😊