Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
6 years ago
Solved

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 ...
  • Pragati11's avatar
    6 years ago

    Hello @MichaelHill ,

    Can you add some screesnhots here please regarding your problem?

    Thank you

    Pragati

  • v-alq-msft's avatar
    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.