Forum Discussion
Solved
Show Items with no Data not working
Hi Team, I have an important query: I have below dataset and i also have a date dimension table which has data up till year 2040, which is connect to this fact table. I have calculated Total Sales u...
I am pretty sure it is because your field "year" is data type "whole number".
Change it to text, and then choose "show items with no data".
I just tested this, and it worked for me
SachinNandanwar
Impactful Individual
Impactful IndividualHi, Convert the chart to a table and check if it displays the expected data.