Starting December 3, join live sessions with database experts and the Microsoft product team to learn just how easy it is to get started
Learn moreGet certified in Microsoft Fabric—for free! For a limited time, get a free DP-600 exam voucher to use by the end of 2024. Register now
How I can filter this bar chart to only keep projects (bars) that have late deliveries, i.e. only show projects A and B in this example? Sample data table is below
Sample data table:
delivery id | Project name | Delivery time |
1 | Project A | On time |
2 | Project B | On time |
3 | Project A | On time |
4 | Project C | On time |
5 | Project C | On time |
6 | Project A | On time |
7 | Project B | On time |
8 | Project C | On time |
9 | Project D | On time |
10 | Project D | On time |
11 | Project A | On time |
12 | Project B | On time |
13 | Project D | On time |
14 | Project E | On time |
15 | Project A | Late |
16 | Project B | Late |
17 | Project A | Late |
Solved! Go to Solution.
hello @fluffysnow
please check if this what you need.
If this what you need, then you can create new measure with conditional if or switch.
Hope this will help you.
Thank you.
Hi @fluffysnow ,
You can just simple add visual level filter on Bar graph ,
where ,
delivery time= late
@manvishah17, thank you for your suggestion, but I do want to show the On time deliveries for these projects. So, your solution is not what I am looking for. I am looking to only display Projects that have late deliveries but I want to display ALL of their deliveries, not only late. Thanks!
hello @fluffysnow
please check if this what you need.
If this what you need, then you can create new measure with conditional if or switch.
Hope this will help you.
Thank you.
@Irwan, thank you so much! It worked perfectly! I really appreciate your help. Thank you for taking the time to help me! 🏅
Hi,
Share the dowload link of the PBI file.
I cant share the file. It's proprietory data. See sample data file above. Thanks!
Starting December 3, join live sessions with database experts and the Fabric product team to learn just how easy it is to get started.
March 31 - April 2, 2025, in Las Vegas, Nevada. Use code MSCUST for a $150 discount! Early Bird pricing ends December 9th.
User | Count |
---|---|
90 | |
87 | |
84 | |
68 | |
49 |
User | Count |
---|---|
131 | |
111 | |
96 | |
71 | |
67 |