Color in scatter plot using calculated measure as text

[manissethi]

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.

[v-diye-msft · Accepted solution]

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-jgbZq...

Best regards,

Dina Ye

[v-diye-msft]

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