Dynamic Conditional Formatting with SWITCH function Measure

Power BI
1

Hi All,

I’m struggling with this one for days already and can’t find solution or at least some explanation why it doesn’t work.

I have a Table with 10 rows for visual. Every row is different Measure, all combined with SWITCH. So far nothing special. For every row I want to apply different conditional formatting since the values have nothing in common. I have created ten “color” measures and combined them with SWITCH to have one for each row in the table, but when I try to apply the measure as a field value it doesn’t allow me. If I try to apply one of the “color” measures is fine, any one of them, but not the SWITCH one.

Thanks in advance!

2

Hi @zhelyazkov1984ivan it would be really helpful if we could have an example PBIX file otherwise we are sort of fumbling around the dark.

1 Like
3

Unfortunately I can’t because it is sensitive company data. I’ll try to create dummy example.

1 Like
4

Hi @zhelyazkov1984ivan,

this forum post might help you in uploading your data

Please also check the How To Mask Sensitive Data thread for some tips on how to mask your pbix file.

Please let us know if you still require assistance for this inquiry

5

Hello @zhelyazkov1984ivan

We notice that no response was received from you on the post above.

We are waiting for your masked demo pbix file and other supporting links and details so other users can help you in your query.

Due to your inactivity, we’ll be tagging this post as Solved.

Should you wish to add your masked demo pbix file and other supporting links and details, you can reopen this thread.

Thank you!