Conditional format bar chart with slicer selection, but also filter other visuals

DAX DAX Calculations
1

Hi,

I have the following design, and I want the specific provider’s bar highlighted when selected in the slicer, but I also want to filter other visuals on the same page.

Is there a way to do this? I have tried to conditional format via dax but am failing.

Any assistance greatly appreciated. PBIX file attached.

desired result
desired result2043×1149 131 KB

conditional format bar chart.pbix (146.3 KB)

2

Hi @jgriffit

I believe this thread should help you:

Highlighting Selected Value from Slicer - Data Visualizations - Enterprise DNA Forum

Thanks,

3

Hello @jgriffit

Did the post suggestion above from @jamie.bryan help solve your query?

If not, can you let us know where you’re stuck and what additional assistance you need?

If it did, please mark the answer as the SOLUTION.

Thank you

4

@jamie.bryan , @jeanrose87

The solution I am after is one slicer (or two with one hidden), that filters connected visuals, and highlights non-connected visuals.

The highlighting works, if selecting the provider from the disconnected slicer, but the result I am after is a solution where I can use a slicer to filter one visual, and highlight another non-filtered visual, without having two slicers on the page. I have attached the example pbix.

I want to just have one slicer, and it filter some things, and highlight something else.

So selecting one provider in the connected slicer, needs to select the same provider in the disconnected slicer.

I have seen it done where a selection in one slicer selects the same in another slicer.

Any assistance would be appreciated.

image
image1755×1002 97.1 KB

conditional format bar chart.pbix (146.9 KB)

5

I’m not sure this is possible - because you need to have the value in the disconnected slicer actually selected, not just filtered.
We can filter the disconnected slicer by the selection in the connected slicer, but not force the value (of the disconnected slicer) to be selected using a DAX measure.

7

Try this. Both the bar chart and the card are based off the disconnected slicer selection.

conditional format bar chart.pbix (76.8 KB)

2 Likes
8

Brilliant @DaveC.

So in summary, you can ignore the model relationships, and filter the disconnected table using a table function ALLSELECTED (or VALUES) in DAX, then use that table to filter another table and calculate a measure.

Everything is TABLES !

Many thanks, I think that was a lightbulb moment in my PBI development.

9

Thanks @Heather

I would have agreed with you , in that you can’t “set the value” of a slicer, until someone showed me this method which does it in a funky way.

But somehow it is done in the attached. I just can’t quite wqork out how yet, I will find it though.

  1. Create a slicer based on the Dimension (Slicer 1)

  2. Create a measure of
    Measure = DISTINCT(‘DimensionTable’[Column])

  3. Insert a new slicer (Slicer 2) based on the measure created in step 2.

  4. There is a step here I can’t find. … until now … found the original post … see

He sync’s the slicers! How cool.

  1. Now when you click on a value in Slicer 1, it filters and sets the item value in Slicer 2.

I would not thought this possible until I saw it.

See attached.

Selection colour highlight Mar2023.pbix (110.6 KB)

@DaveC - see above for another really interesting way.

Thanks both for your responses.

2 Likes
10

John,

The use of disconnected tables and slicers to do conditional formatting is a really powerful combo. Here’s a recent post I did demonstrating some other cool twists on that approach that you may find helpful:

  • Brian
11

@jgriffit - that is a very nice trick - I hadn’t seen anyone sync slicers from different tables before. Thank you for bringing this example to the forum.

@DaveC - very slick solution!