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,
I tried to show a daily trend of sales by using column chart consisting of the date axis (has to be categorical for format purposes) and values, however, entries without items don't show despite using the "Show items with no data" option. Is there any way to get all values displayed even for days without sales?
It frankly looks like that:
Solved! Go to Solution.
@KosKoul - The relationship between the 2 tables is Bi-directional. Please change the relationship so that Programmes does not filter Dates and let us know whether that fixes the issue.
@KosKoul - You'll need to:
Date = CALENDAR(DATE(2019,1,1), DATE(2019,12,31))
Thanks @Anonymous,
I forgot to say in the initial post that I have already created a dates table using exactly the same DAX command but I still get the same problem - dates without sales still don't display.
@KosKoul - I think it should work, as long as the axis is using the date from the date table. Could you share a screenshot that shows the various columns in use?
Hi @Anonymous,
The dates column on the table I created (format is Date type and Customised to display as d mmm) is here:
This is connected to a corresponding column from my main dataset with the same format:
As mentioned in the previous post, on the report mode, the x axis in the chart is shown as categorical (so I can keep the format) and the 'Show Items without data' option is ticked.
Not sure if that's sufficient, but I'm happy to provide further info if necessary.
@KosKoul - The relationship between the 2 tables is Bi-directional. Please change the relationship so that Programmes does not filter Dates and let us know whether that fixes the issue.
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 |