Forum Discussion
Anonymous
6 years agoNot applicable
PBI Desktop Aug. 2020 - Web URL and Matrix Report does not work with conditional formatting
Hi, I'm working with PBI Desktop August 2020 version and trying to use a Web URL within a matrix report. I have a column "Date" and a row "Test_name". The values are KPIs to indicate wether a test ...
- 6 years ago
Hello @MichaelHill ,
Can you add some screesnhots here please regarding your problem?
Thank you
Pragati
- 5 years ago
Hi, Anonymous
Based on your description, I created data to reproducce your scenario. The pbix file is attached in the end.
Table:
You may create measures like below.
URL = SWITCH( SELECTEDVALUE('Table'[ID]), 1,"https://www.google.com/", 2,"https://www.daxformatter.com/" ) Color Control = SWITCH( SELECTEDVALUE('Table'[ID]), 1,"red", 2,"green" )Then you may set the 'Data category' for 'URL' as 'Web URL' and conditional formatting the background of 'URL' as below.
Result:
Best Regards
Allan
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
Pragati11
Super User
6 years agoHello @MichaelHill ,
Can you add some screesnhots here please regarding your problem?
Thank you
Pragati