Forum Discussion

Madhu155's avatar
Madhu155
Frequent Visitor
1 year ago
Solved

Issue with Displaying All Days as Values from Calendar Table Using DAX Measure

Hi Everyone, I am facing an issue with the "Day" column from the calendar table. When using the following measure, only the day values are displayed from the column which as values from the fact...
"DAX "
"DAX " "DAX help" 'Need help'
CALENDER
DAX Command
  • Anonymous's avatar
    Anonymous
    1 year ago

    Thanks for the replies from Rupak_bi, FreemanZ and FarhanJeelani.

     

    Hi Madhu155 ,

     

    If you want to display a value that has no data and does not need to be displayed as 0. You can select a visual. In the Values fields well, right-click the field and select Show items with no data from the menu.

    The Show items with no data feature lets you include data rows and columns that don't contain measure data (blank measure values).

     

    Best Regards,
    Zhu

     

    If there is any post helps, then please consider Accept it as the solution  to help the other members find it more quickly.

Anonymous's avatar
Anonymous
Not applicable
1 year ago

Thanks for the replies from Rupak_bi, FreemanZ and FarhanJeelani.

 

Hi Madhu155 ,

 

If you want to display a value that has no data and does not need to be displayed as 0. You can select a visual. In the Values fields well, right-click the field and select Show items with no data from the menu.

The Show items with no data feature lets you include data rows and columns that don't contain measure data (blank measure values).

 

Best Regards,
Zhu

 

If there is any post helps, then please consider Accept it as the solution  to help the other members find it more quickly.