Forum Discussion
Power ParticipantShow rows with no data
Hi,
I have a number of Age Profile tables that only show the range of dates if data exists within that range:
As you can see, 3-6mths, 6-9mths and so on are all missing.
Is there a way to have them all showing because I don't like the Matrix as it is.
I have a version where I am counting ID numbers and a Measure version here:
YTD Total = CALCULATE(
TOTALYTD(COUNT('Cases'[Case Number]),'Cases'[Resolution Date],"31/03"),
'Cases'[statecode] = "Resolved")
Thanks,
6 Replies
ArchStantonI've been told that the problem is that the age ranges are a calculated column.
To make it work I'll need to create a dimension and then link it to the calculated column.
Not done this before so I'm assuming the Dimension will be my age ranges and I'll be using that in the visual instead.
Hi ArchStanton
Have you solved your problem? If so, can you share your solution here and mark the correct answer as a standard answer to help other members find it faster? Thank you very much for your kind cooperation!
Best Regards
Zhengdong Xu
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
- audreygerred
Super User
Hi! In the visualization pane, go to your field for the age profile, right click and put show items with no data.
- ArchStanton
Just tried that thanks but unfortunately it doesn't work.
FYI: The age profile and Category (A,B,C,D) are calculated columns.If there is no value in e.g, 3-6mths then I'm not entirely sure if its even possible to show it?
Hi ArchStanton
If the show items with no data doesn't work, maybe you can replace the blank value into 0 or other value to represent that is blank, it's an alternative workaround.
For example:
Here's a link for your reference:
Show items with no data in Power BI - Power BI | Microsoft Learn
Best Regards
Zhengdong Xu
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
