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.
Hello,
I search the forum first before posting. If a solution is already posted, please direct me to the post (if forum rules permit).
Background
Below are 2 screenshots of my first dashboard (which is still in use) (see page 3).
The visual consist of slicers, tables, and a waterfall chart.
The data is airline passenger data with row dimensions for:
Column dimenstions are this year's data, last years data, and YOY change percent.
Problem
All totals sum correctly. If this year's data does not have a data dimension, but the data dimension existed for last year, the row for that dimension is missing. The total rows are correct.
Screen Shots
The first screen shot shows passenger data sliced for April 2019.
The second screen shot shows passenger data sliced for April 2020.
Special Note
For the affected dimension (Domestic / International) I do not have any visual, page, or report level filters filtering out blank or zero.
Request
How can I disply the missing row?
Thx in advance for all your help!
hi @DAXRichArd
Could you please share your sample pbix file for us have a test, that will be a great help.
Regards,
Lin
Hi @v-lili6-msft ,
I shared a file once, but I don't recall how. I thought it was through private message but I don't see that feature.
Do you know of a service I could share my file with you?
hi @DAXRichArd
You can upload it to OneDrive for buiness and post the link here. Do mask sensitive data before uploading.
Regards,
Lin
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 |
---|---|
114 | |
97 | |
86 | |
70 | |
62 |
User | Count |
---|---|
151 | |
120 | |
103 | |
87 | |
68 |