Forum Discussion

manissethi's avatar
manissethi
Regular Visitor
7 years ago
Solved

Color in scatter plot using calculated measure as text

Hi All,

 

I am trying to use a calculated measure to split a Risk Score value in my dataset into High/Medium/Low using slicer values and then using a calculated measure to show color of each transaction as Red - High, Yellow - Medium and Green - Low. 

This should be a fixed color scheme and not a divering one. 

 

Also will it be possible to add filtering on visuals using a calculated measure created for High/Medium/Low ?

Any help would be highly appreciated.

Thanks in advance.

Need Help
  • v-diye-msft's avatar
    v-diye-msft
    7 years ago

    Hi manissethi 

     

    Assuming that we have a sample with [Forename] [Score] and [Curriculum],  not sure if you’d like to show the value as below. If not, please help provide more details about your request.

     

    Please note that create the slice using measure is not accessible, thus I use calculated column instead:

    Slicer column = IF([Score]>3,"High",IF([Score]=3,"Medium",IF([Score]<3,"Low")))

    Then use measure to set the conditional format :

    Measure 2 = IF(MAX(Table1[Slicer column])="High","#FF0A18",IF(MAX(Table1[Slicer column])="Medium","#F0FF9A",IF(MAX(Table1[Slicer column])="Low","#00FF37")))

    You can find the color code under Format pane.

    Then

    Finally:

    Pbix attached here for your reference: https://wicren-my.sharepoint.com/:u:/g/personal/dinaye_wicren_onmicrosoft_com/EUBO626SMOpDoUWe-jgbZqkBwQ5rdW34cpPmGyznhBWvSQ?e=FH2N9I

    Best regards,

    Dina Ye

2 Replies

  • v-diye-msft's avatar
    v-diye-msft
    Community Support
    7 years ago

    Hi manissethi 

     

    Assuming that we have a sample with [Forename] [Score] and [Curriculum],  not sure if you’d like to show the value as below. If not, please help provide more details about your request.

     

    Please note that create the slice using measure is not accessible, thus I use calculated column instead:

    Slicer column = IF([Score]>3,"High",IF([Score]=3,"Medium",IF([Score]<3,"Low")))

    Then use measure to set the conditional format :

    Measure 2 = IF(MAX(Table1[Slicer column])="High","#FF0A18",IF(MAX(Table1[Slicer column])="Medium","#F0FF9A",IF(MAX(Table1[Slicer column])="Low","#00FF37")))

    You can find the color code under Format pane.

    Then

    Finally:

    Pbix attached here for your reference: https://wicren-my.sharepoint.com/:u:/g/personal/dinaye_wicren_onmicrosoft_com/EUBO626SMOpDoUWe-jgbZqkBwQ5rdW34cpPmGyznhBWvSQ?e=FH2N9I

    Best regards,

    Dina Ye

    • v-diye-msft's avatar
      v-diye-msft
      Community Support
      7 years ago

      Hi manissethi 

       

      If my above post helps, could you please consider Accept it as the solution to help the other members find it more quickly. thanks!

       

      Best regards,

      Dina Ye