Color bar chart by slicer selection (DAX + conditional formatting)

DAX DAX Calculations
2

HI @michellepace,

  1. You can create a table with 1 column i.e MyWeekEnding and do not connect it.

image
image764×736 12.4 KB

  1. Then create measure as below,

Selected Library = IF(MIN(Dates[MyWeekEnding]) = SELECTEDVALUE('Value(for slicer)'[MyWeekEnding]), 1)

  1. Then do color formatting as below:

a. With bar table selected goto format:
image

b. Then format as shown below.

image
image1367×943 19.2 KB

  1. And change your slicer with new created table.
    image
    image1736×792 70.4 KB

Below will show you week 26 as selected in red, change the color as per your choice.

image
image1706×836 73.9 KB

Sorry I can’t upload pbix file as i used my office system.

2 Likes