Power BI is turning 10! Tune in for a special live episode on July 24 with behind-the-scenes stories, product evolution highlights, and a sneak peek at what’s in store for the future.
Save the dateEnhance your career with this limited time 50% discount on Fabric and Power BI exams. Ends August 31st. Request your voucher.
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 🙂
Solved! Go to 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.
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.
I like your suggestion v-chenwuz-msft 👍
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.
hey @speedramps not sure if you can see my reply or not appreciate the help on this
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.
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.
User | Count |
---|---|
76 | |
76 | |
41 | |
29 | |
24 |
User | Count |
---|---|
96 | |
91 | |
52 | |
46 | |
45 |