Check your eligibility for this 50% exam voucher offer and join us for free live learning sessions to get prepared for Exam DP-700.
Get StartedDon't miss out! 2025 Microsoft Fabric Community Conference, March 31 - April 2, Las Vegas, Nevada. Use code MSCUST for a $150 discount. Prices go up February 11th. Register now.
I have what I thought is a straight forward table and bar chart. The original table has a column "IsOutOfStock" that shows either True or False. The bar chart is supposed to reflect the number of "IsOutOfStock" rows that are "True" grouped by the Date. When I click DrillIthrough I want to be able to filter the underlying table by Date and the correct "IsOutOfStock" state, in this case True. However, when I do this while it does filter the Date correctly I still get the rows that reflect "False". Initially I created a measure to count them:
Date | InternalShipmentNum | IsOutOfStock | IsOutOfStockNum |
1/29/2020 | 1075009 | FALSE | 0 |
1/29/2020 | 1075003 | FALSE | 0 |
1/28/2020 | 1074235 | FALSE | 0 |
1/28/2020 | 1074936 | FALSE | 0 |
1/29/2020 | 1074235 | TRUE | 1 |
1/29/2020 | 1074235 | TRUE | 1 |
1/29/2020 | 1074235 | TRUE | 1 |
1/28/2020 | 1074235 | TRUE | 1 |
1/28/2020 | 1075012 | TRUE | 1 |
Solved! Go to Solution.
Hi,
After my test, i use your measure and it shows the correct result:
The above shows the correct number of 'IsOutOfStock' rows that are 'True' grouped by the Date.
Here is the test pbix file.
If i misunderstand your requirement, please for free to let me know.
Best Regards,
Giotto Zhi
Thank you Giotto. Downloading your file helped me realize what I was doing incorrectly. I had created a separate table in the Fields pane to hold all of my measures to keep them organized without thinking about the fact that I needed to keep that particular measure within the same table to make this work. I moved it to the correct table and it now works. Sometimes its the simple things. Thank you again.
Hi,
After my test, i use your measure and it shows the correct result:
The above shows the correct number of 'IsOutOfStock' rows that are 'True' grouped by the Date.
Here is the test pbix file.
If i misunderstand your requirement, please for free to let me know.
Best Regards,
Giotto Zhi
March 31 - April 2, 2025, in Las Vegas, Nevada. Use code MSCUST for a $150 discount! Prices go up Feb. 11th.
Check out the January 2025 Power BI update to learn about new features in Reporting, Modeling, and Data Connectivity.
User | Count |
---|---|
146 | |
75 | |
64 | |
52 | |
47 |
User | Count |
---|---|
218 | |
88 | |
73 | |
64 | |
60 |