mardi 11 juin 2019

How to get bar chart to highlight bar when element is selected in filter/slicer

[POWER BI]

Hi,

I want the bar in a bar chart to highligt when the value is selected in the slicer. Hence, i want all values to show and highlight the selected value.

Desired Result

I created a pretty simple measure that gives the value 1 when a value is selected in the slicer and 0 when nothing is selected.

Measure = if(ISFILTERED(Table1[Namn]);1;0). When i look at the result in a card it looks like it works. Result1 Result2. But when I look at the results in a table the value it is always 1.

I added the measure in the conditional formatting for the barchart like this: CONDITIONAL FORMATTING. It Changes the color of the bar chart according to value 1 and does not change wether or not an element is selected or not. Can somebody explain why this is happening or if there is any other solution to highlight a bar in a bar chart according to the selected element in the slicer?

Kind regards -

Aucun commentaire:

Enregistrer un commentaire