Conditional Filtering

[Anonymous]

Hi there,

This is my first time asking a question on the forum so forgive any novicey language and/or ignorance.

Is it possible to action a filter based off another column filter ? Essentially what i want to do is when a user Selects a certain product category (Sports, Menswear etc) I want it to filter the corresponding training column. So theres a "sports training" column set to "True/False" same for menswear and so on.

So if the user selects Sports then i want the data to be also filtered to "sports training" = True" -- and if someone selects Menswear then "Menswear Training" = True.

Hope this makes sense really would appreciate help on this 🙂

[speedramps]

I like your suggestion v-chenwuz-msft 👍

[speedramps]

I am still not sure what you want, please can you improve the problem description and I will try help

Boolean behaves strangley on Power BI slicer which can be confussing for BI novices.

Try this ...

In the query editor change the True/False data types from Boolean to text or Y/N.

Delete all your slicers values and add them again.

This is much simpler to understand.

If you dont believe me then try compare the behavior of a boolean and text True and False column in a slicer.

Novices think that  True and False  boolean  will save disk space compared to text .
That is true on SQL row databases but Power Bi is collumnar database.

So use text and not boolean in Power BI.

Please click thumbs upand accept as solution button. 😀

If you have 1 query, 1 report visual; and 3 slicers (menswear, kids, sport).

As you you slect one or more slicers the other slicer(s) and report which shink accordingley.

Just like on ebay or Amazon slicers.   

[Anonymous]

hey @speedramps not sure if you can see my reply or not appreciate the help on this

[speedramps]

Please provide example data as table(s) not a screen shot

and example output with a better description

so we can help you. 

You can copy and paste table date into this forum but remeber to remove any privarte data 😀

[Anonymous]

Thank you for your swift reponse of course example data would have been helpful !! Here is a snippet of my data in tabular format. You can see the category in the first column - in Power Bi i want to condition filter the training columns with respect to its corresponding product. Hope this makes sense 🙂

Product Classification Code 1	Menswear Training Completed	Sports Training Completed	Kids Training Completed	Sales
Menswear	TRUE	FALSE	FALSE	55
Sports	FALSE	TRUE	FALSE	20
Kids	FALSE	FALSE	TRUE	58

[v-chenwuz-msft · Accepted solution]

Hi @Anonymous ,

1 unpivot the column and let the table looks like this:

2 create a measure and put it in the values of martix table.

Measure = IF(SELECTEDVALUE('Table'[Value])="FALSE",BLANK(),SUM('Table'[Sales ]))

Result:

Pbix in the end you can refer.

Best Regards

Community Support Team _ chenwu zhu

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