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.
Hi all,
Using Power BI Desktop July, 2021.
I have a Calendar and Sales Tables
The tables are 1:M on Date Field.
I put the DayName on Rows in Matrix Visual
I then added Total Sales to Values
As soon as I add Total Sales to Values, the DayName disappears from the Matrix
I tried to make the column wider for the DayName - no help.
If I remove Total Sales from Values, the DayName displays on the Matrix again.
Any ideas?
Thanks,
-w
Solved! Go to Solution.
The OrderDate column on your Sales table is formatted as text. Change that to type Date and it will work.
Pat
To learn more about Power BI, follow me on Twitter or subscribe on YouTube.
Thanks Pat,
The Order Date in the Sales Table was the culprit - thanks!
-w
Thanks Jihwan,
I uploaded to OneDrive : https://tinyurl.com/jm4deeea
If it does not take you directly to the pbix its in //public/power_bi/aw2.pbix
The 2 Matrices are on Page 9.
Thanks,
-w
-w
The OrderDate column on your Sales table is formatted as text. Change that to type Date and it will work.
Pat
To learn more about Power BI, follow me on Twitter or subscribe on YouTube.
Hi,
I am not sure how your data model looks like, but in my opinion, it seems like there is an invalid relationship between fact table and date table.
If it is OK with you, please share your sample pbix file, then I can try to look into it to come up with a relevant solution.
Thanks.
If this post helps, then please consider accepting it as the solution to help other members find it faster, and give a big thumbs up.
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 |
---|---|
109 | |
98 | |
77 | |
66 | |
54 |
User | Count |
---|---|
144 | |
104 | |
100 | |
86 | |
64 |