Show rows with no data

[ArchStanton]

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,

[ArchStanton]

I'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.

[Anonymous]

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]

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?

[Anonymous]

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.

[ArchStanton]

Hi,
Thanks for your reply.

The problem is that some values don't exist in this calculated column (there are no incidents within 3-6mths in the data so there is nothing to count). If they don't exist then there is nothing to turn into a zero. Is it even possible to display all of these age ranges without data to count?

Age Profile = 
SWITCH (
    TRUE (),
    ISBLANK ( [Validation to Closure] ), BLANK (),
    [Validation to Closure] < 91.3,
        REPT ( UNICHAR ( 8203 ), 1 ) & "" & " 0-3 Mths",
    [Validation to Closure] < 182.5,
        REPT ( UNICHAR ( 8203 ), 2 ) & "" & " 3-6 Mths",
    [Validation to Closure] < 273.5,
        REPT ( UNICHAR ( 8203 ), 3 ) & "" & " 6-9 Mths",
    [Validation to Closure] < 365.25,
        REPT ( UNICHAR ( 8203 ), 4 ) & "" & " 9-12 Mths",
    [Validation to Closure] < 456.25,
        REPT ( UNICHAR ( 8203 ), 5 ) & "" & " 12-15 Mths",
    [Validation to Closure] < 547.5,
        REPT ( UNICHAR ( 8203 ), 6 ) & "" & " 15-18 Mths",
    [Validation to Closure] < 638.75,
        REPT ( UNICHAR ( 8203 ), 7 ) & "" & " 18-21 Mths",
    [Validation to Closure] < 730.5,
        REPT ( UNICHAR ( 8203 ), 8 ) & "" & " 21-24 Mths",
    [Validation to Closure] < 821.5,
        REPT ( UNICHAR ( 8203 ), 9 ) & "" & " 24-27 Mths",
    [Validation to Closure] < 912.5,
        REPT ( UNICHAR ( 8203 ), 10 ) & "" & " 27-30 Mths",
    [Validation to Closure] < 1004.5,
        REPT ( UNICHAR ( 8203 ), 11 ) & "" & " 30-33 Mths",
    [Validation to Closure] < 1095.5,
        REPT ( UNICHAR ( 8203 ), 12 ) & "" & " 33-36 Mths",
    REPT ( UNICHAR ( 8203 ), 13 ) & " 36+ Mths"
)