Forum Discussion

rcheskin's avatar
rcheskin
Icon for Helper I rankHelper I
5 years ago

Slicer to toggle color blind friendly theme

Some of our users are color blind, so I want to implement a slicer that changes the color theme of a line chart.  I have been able to do this in the past when the number of categories is a known quan...
Need Help
v-kkf-msft's avatar
v-kkf-msft
Icon for Community Support rankCommunity Support
5 years ago

Hi rcheskin ,

 

Try to create measures shown below for the top 8 data.

 

Rank = 
RANKX(
    ALLSELECTED('Table'[ID]),
    CALCULATE( SUM('Table'[Value]) )
)
Color = 
SWITCH(
    [Rank],
    1, "#1AFF1A",
    2, "#4B0092",
    3, "#B3B3B3",
    4, "#66DF60",
    "#D64550"
)

If the problem is still not resolved, please provide detailed error information or the expected result you expect. Let me know immediately, looking forward to your reply.

Best Regards,
Winniz

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

rcheskin's avatar
rcheskin
Icon for Helper I rankHelper I
5 years ago

Hi v-kkf-msft , 

This method does not work with line charts because there is no option to specify conditional formatting of colors.