Microsoft Fabric Community Conference 2025, March 31 - April 2, Las Vegas, Nevada. Use code MSCUST for a $150 discount.
Register nowThe Power BI DataViz World Championships are on! With four chances to enter, you could win a spot in the LIVE Grand Finale in Las Vegas. Show off your skills.
This is frustrating me and I've spun my wheels long enough on it, so now I'm coming for help.
I have a simple report where the user selects the current month and I have a table that should show current month vs previous months for a value. It works fine when the current month has a value, but if there isn't a value for the current month for a given "Ship To", then it won't display the Ship To and consequently, won't show the previous value if there is one. Here is a look at the report:
What you don't see here is the missing records where there was an FSC Dollars value in 7/1/22 for other Ship Tos, but because there was no value for 8/1/22, it's been dropped from the table. Here are my measures:
Hi @esuing ,
Try to click one of your fields, and select the option "Show items with no data".
And then your items with no data will display.
Reference: Show items with no data in Power BI - Power BI | Microsoft Learn
Best Regards,
Stephen Tao
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
Thanks for the reply. Unfortunately, this did not resolve the issue.
Thanks.
Eric
User | Count |
---|---|
120 | |
65 | |
62 | |
56 | |
50 |
User | Count |
---|---|
177 | |
85 | |
70 | |
63 | |
55 |