top of page

One Chart Many Colors - Chart Hierarchy with Conditional Formatting (Toggle Chart)

Some time you wish you have different colors for each month and Years in a Chart where the Axis is shared by both Year and Month (Chart Hierarchy). Some times I noticed this is a manual task among users of Power BI but you can automate this with simple Conditional Formatting using SWITCH and SELECTEDVALUE Function. You can Toggle the chart between Year and Month and can have Different Colors based on Condition.

Keep Learning ! Please SUBSCRIBE!!

135 views0 comments
bottom of page