Make measure for table to change multiple "related" columns at once

[Namoh]

Hi guru's of Power BI,

I have a challenge.

I made this visualisation, which enables me to select a certain measure and show the related values for the facilities (with measure 1 the 1st record can be facility A, with measure 2 the 1st record can be facility D, etc).

I also have below graphs, which shows the Actual, Target, Deviation, Actual YTD, Target YTD & Deviation YTD for one particular type of loss, in this case: Unplanned Loss. I have 4 other Tabs with the same tables but then for different Type of Losses.
Having so many Tabs is not user-friendly.

It would be much nicer if I could have one Tab with the two graphs and a slicer where I can select the Type of Losses, and the graphs would show the related columns.

Is this possible? 

I hope it makes sense what I want.

Any clue how to do this?

[v-yingjl]

Hi @Namoh ,

Seems like you want to filter column data based on the conditional format.

Create a calculated table like this based on your format rules and use it as a slicer:

Rules Table = 
UNION(
    ROW("Rule","> 20 && < 100"),
    ROW("Rule",">= 100 && < 150"),
    ROW("Rule",">= 150 && < 200"),
    ROW("Rule",">= 200 && < 1000")
    )

Create a measure like this, set its value as 1 and put it in the visual filter:

Visual control = 
SWITCH(
    SELECTEDVALUE('Rules Table'[Rule]),
    "> 20 && < 100", IF([Acutal] > 20 && [Acutal] < 100,1,0),
    ">= 100 && < 150", IF([Acutal] >= 100 && [Acutal] < 150,1,0),
    ">= 150 && < 200", IF([Acutal] >= 150 && [Acutal] < 200,1,0),
    ">= 200 && < 1000", IF([Acutal] >= 200 && [Acutal] < 1000,1,0),
    1
)

Attached a sample file in the below, hopes it could help.

Best Regards,
Community Support Team _ Yingjie Li
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.