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 am trying to drill down from FY to Month and so on and when I do I get this error. This is a DL'd PBI that I haven't created the relationships on and do not have access to the source data.
Hi @bw70316
You may go to 'Subtotals' under format pane to turn off the column which has 'AAS' values.
Regards,
Cherie
I figured out it was because all my Budgeted Amounts Load on that date. Causing the issue. I don't know how to get unique values for those expense types if I don't have a proper date however.
Hi @bw70316
This is due to Power BI being a aggregation tool. You may drill down to Days to get unique values.Power BI also removes duplicate rows from a table by default. The way around this would be to create an index column to provide the uniqueness of rows.
Regards,
Cherie
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 |
---|---|
112 | |
100 | |
76 | |
74 | |
49 |
User | Count |
---|---|
145 | |
108 | |
107 | |
89 | |
61 |