Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.
I want to filter and show data according to the category. which should be filtered in my Table chart
Product_id | Product Name | Category |
1 | a | Mobile |
2 | b | Charger |
3 | c | Mobile |
4 | d | Mobile |
5 | e | Charger |
6 | f | Headset |
7 | g | Charger |
8 | h | headset |
9 | i | Mobile |
10 | j | Charger |
I want to display whose category is Headset & Mobile
Solved! Go to Solution.
Hi @arun3039,
You may try this solution.
1 Create a measure like this
FilterTable = CALCULATE(MAX('Table'[Category]),'Table'[Category] IN {"Headset","Mobile"})
2 Add filters on this visual to show items when the value is not blank
In fact, you could simply use Filters pane to achieve it: just tick the category you need to show but leave other catetories unticked.
Attached the pbix file as reference.
If there is any post helps, then please consider Accept it as the solution to help the other members find it more quickly. If I misunderstand your needs or you still have problems on it, please let me know. Thanks a lot!
Best Regards,
Community Support Team _ Caiyun
Hi @arun3039,
You may try this solution.
1 Create a measure like this
FilterTable = CALCULATE(MAX('Table'[Category]),'Table'[Category] IN {"Headset","Mobile"})
2 Add filters on this visual to show items when the value is not blank
In fact, you could simply use Filters pane to achieve it: just tick the category you need to show but leave other catetories unticked.
Attached the pbix file as reference.
If there is any post helps, then please consider Accept it as the solution to help the other members find it more quickly. If I misunderstand your needs or you still have problems on it, please let me know. Thanks a lot!
Best Regards,
Community Support Team _ Caiyun
Thanks Amitchandak, Its displaying count with category, but i want to display filter rows on that table Chart.
@arun3039 , Create a measure and use that with product and product if in visual
calculate(countrows(Table), filter(Table, Table[Category] in{"Headset","Mobile"}))
Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City
Check out the April 2024 Power BI update to learn about new features.
User | Count |
---|---|
47 | |
26 | |
19 | |
15 | |
10 |
User | Count |
---|---|
58 | |
50 | |
44 | |
19 | |
19 |