Forum Discussion
Dynamic Colors for Bar Chart Visualization
Anonymous , The constant line(under analytics pane) has the option of fx. You can choose a measure.
You can use the measure slicer approach to change measure for fx
measure slicer
https://www.youtube.com/watch?v=b9352Vxuj-M
https://community.powerbi.com/t5/Desktop/Slicer-MTD-QTD-YTD-to-filter-dates-using-the-slicer/td-p/500115
https://radacad.com/change-the-column-or-measure-value-in-a-power-bi-visual-by-selection-of-the-slicer-parameter-table-patternSame way you can create a measure color and use that in conditional formatting using field value option
Color = Switch( True() ,
[Bar Meausre] > [selected measure], "Green",
"Red"
)
How to do conditional formatting by measure and apply it on pie?: https://youtu.be/RqBb5eBf_I4
Super UserAnonymous , The constant line(under analytics pane) has the option of fx. You can choose a measure.
You can use the measure slicer approach to change measure for fx
measure slicer
https://www.youtube.com/watch?v=b9352Vxuj-M
https://community.powerbi.com/t5/Desktop/Slicer-MTD-QTD-YTD-to-filter-dates-using-the-slicer/td-p/500115
https://radacad.com/change-the-column-or-measure-value-in-a-power-bi-visual-by-selection-of-the-slicer-parameter-table-pattern
Same way you can create a measure color and use that in conditional formatting using field value option
Color = Switch( True() ,
[Bar Meausre] > [selected measure], "Green",
"Red"
)
How to do conditional formatting by measure and apply it on pie?: https://youtu.be/RqBb5eBf_I4
Thank you so much for all the help over the past 2 years on this website.
Also, great youtube channel too. Thank you again!