Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
2 years ago

Want Table to show zero value

I have a table visual with job titles and filtered to only show "(L2) Apprentice Level 3, (L3) Apprentice Level 5, (UQ) Apprentice Level 3, Nursery Apprentice Level 2, (L2) Apprentice Level 5, (UQ) A...
Need Help
amitchandak's avatar
amitchandak
Super User
2 years ago

Anonymous , Right click on the  job Title in the visualization pa/build a visual pane and use Show items with not data

 

Anonymous's avatar
Anonymous
Not applicable
2 years ago

Hi 

 

Thank you very much in taking this time in helpig me. But even after changing this it doesn't seems working. Attached the screen shot

 

 

 

 

  • Anonymous's avatar
    Anonymous
    Not applicable
    2 years ago

    Any help on the above pls?

     

    • Anonymous's avatar
      Anonymous
      Not applicable
      2 years ago

      I created a new measure table and built relation with the actual data source column, which helped me to display the selected job titles even if they did not have any values.  The below is the DAX measure I used to create a new table: 

      But now the issue is the table just displays blank when there is no value and I want it to display Zero if its blank. Attaching screen shot for reference. 

       

       

       

       

      Any help?