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!!

138 views0 comments

Recent Posts

See All


The CurrentMonth function in Excel!? This custom function using LAMBDA will a quick help to get summary. Stay tuned for a full tutorial and even an Excel file to follow along with. #excel #lambda http


bottom of page