topic Re: Maintain Colour After Drill-down in DAX Commands and Tips

Maintain Colour After Drill-down

Anonymous — Wed, 01 Feb 2023 19:53:24 GMT

Hi,

I have a variable 'HSE Observation'[CategoryRating] that is 4 layours down into a drill-down pie chart. This is what it looks like without drilling down into the above levels (from selecting the colours in the "Slices" drop-down within Visualisations):

When I drill-down to the CategoryRating via drilling into the 3 layers above this, the colours changes based on the report theme but I want to keep the original (above) colours. This is what it looks like now:

Is there a way to maintain the original colours without it changing back to theme colours?

Note: I am live connected to the dataset.

Thank you

Re: Maintain Colour After Drill-down

amitchandak — Thu, 02 Feb 2023 02:24:30 GMT

Anonymous , refer if conditional formatting can help

How to do conditional formatting by measure and apply it on pie?
https://www.youtube.com/watch?v=RqBb5eBf_I4&list=PLPaNVDMhUXGYo50Ajmr4SgSV9HIQLxc8L
https://community.powerbi.com/t5/Community-Blog/Power-BI-Conditional-formatting-the-Pie-Visual/ba-p/1682539
https://amitchandak.medium.com/power-bi-where-is-the-conditional-formatting-option-in-new-format-pane-66e0afcb15f3

Re: Maintain Colour After Drill-down

Anonymous — Thu, 02 Feb 2023 08:47:30 GMT

Hi Anonymous ,

You can drill through to a specified level and assign a color to the corresponding group, and once you change the color, it will not change after that.

Format – Visual -- Slicer.

Best Regards,

Liu Yang

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

Re: Maintain Colour After Drill-down

Anonymous — Thu, 02 Feb 2023 13:32:37 GMT

Hi amitchandak,

I created the measure for assosiating the category name to a colour, but it won't let me use the measure as the field base:

Please could I have some assistance on this? Thanks