Forum Discussion
Conditional Filtering
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 🙂
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.
6 Replies
I like your suggestion v-chenwuz-msft 👍
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 😀
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 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.
hey speedramps not sure if you can see my reply or not appreciate the help on this
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.
