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.
Hi Everyone, I'm quite stuck on something.
My data has Year, Quarter, Category, Sub-category, and Value
When added to a matrix, I have a custom column order for the years using a seperate YearOrder table:
When adding the 'Year' column to the matrix from the sortOrder table, one of the years goes missing (2022 Actuals). If I replace it with the 'Year' from the original table, the year shows up again. Why is it going missing? I've triple checked spelling- I have no idea why it's behaving this way. Am I missing something?
I'm not having any issues with missing columns in other matrices using the same YearOrder table.
Is it possible there's a hidden space or carriage return coming in on your main table?
If you go into power query, right click the column and use the "TRIM" option and just to be sure "CLEAN" option in the transform to throw away any weirdness I'm hoping it might spring into life.
Your solution makes sense but unfortunately it didn't work . I cleaned and trimmed both YearOrder and the data table but the column is still missing
Not an obvious one!
Few questions on things to check:
Is anything lurking in the report/page filters?
Are any other visuals/slicers interacting?
Are you using a measure in the matrix. If so can you share. Wondering if it is returning blank for some reason.
1. There are no filters
2. I put the visual in a new page - nothing is interacting with it
3. There are no measures:
I filtered the visual using YearOrder table to only show the missing column and the matrix returns a blank:
Just realised it's 2022 Actuals...
Presumably you have no data for 2022. Value is therefore blank so it will hide.
I think if you click arrow on "Year" in the column section there should be a show blanks. (Will check wording when next on a computer)
I have dummy data in 2022 Actuals for testing purposes. When I select show items with no data, 2022 Actuals shows up but is indeed blank! When I replace 'Year' in the matrix with the one from the data table, 2022 Actuals column shows with the dummy data, so the mystery remains
with Year from YearOrder table
with Year from Data table
Hi,
Share the link from where i can download your PBI file.
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 |
---|---|
144 | |
80 | |
64 | |
52 | |
49 |
User | Count |
---|---|
217 | |
89 | |
76 | |
66 | |
60 |