Forum Discussion

KKVerma's avatar
KKVerma
Regular Visitor
2 years ago
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 using the below dax:

Total Sales = CALCULATE(SUM(FctTest[Amount]),KEEPFILTERS(FctTest[Type]="Sales"))

 

I am trying to plot this in the line chart below. I have checked the mark where it says "Show Items with no data". However, on the x axis, it is still showing those 4 years. ideally it should show all the years presented in the date dimension table.  

 

 

Could you please help me understand, what is it that i am missing?

#powerBI dax 

 

 

 

 

  • TrevLc's avatar
    TrevLc
    2 years ago

    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

3 Replies

  • SachinNandanwar's avatar
    SachinNandanwar
    Icon for Impactful Individual rankImpactful Individual
    2 years ago

    Hi, Convert the chart to a table and check if it displays the expected data.

  • TrevLc's avatar
    TrevLc
    Icon for Helper III rankHelper III
    2 years ago

    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

  • KKVerma's avatar
    KKVerma
    Regular Visitor
    2 years ago

    It seems like the issue is with this chart type only. Bcose stacked column chart displays all the years without converting the years to categorical type in the visual. Thank you