Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
7 years ago
Solved

Show value with no data when filtering

Hello! I am a new Power BI user. I did some research on my question but was not able to find a solution.   I am trying to show a visualization (bar graph or matrix) that counts how many bugs are in...
Need Help
parry2k's avatar
parry2k
Super User
7 years ago

Anonymous you can achieve with following steps:

 

create  new table for type using dax below

 

 

TypeTable = VALUES( YourTable[Type] )

 

 

Now create a measure for count using following DAX

 

Count Rows = 
CALCULATE(
Countrows( YourTable ), 
TREATAS( VALUES( TypeTable[Type] ), YourTable[Type] )
 )

Now on graph, use type on x-axis and slicer from new typetable 

 

And it should work.

  • Anonymous's avatar
    Anonymous
    Not applicable
    7 years ago

    Thanks parry2k , I appreciate the help.

    I created the suggested TypeTable and Count Rows measures, but was unable to get the desired result (still cannot see Sprint 3 in the bar graph). I want to keep the Sprint field on the x-axis, not the Type field (see image in original post). Let me know if the data I pulled into the Axis, Type, and Count Rows fields are incorrect.

     

     

    • parry2k's avatar
      parry2k
      Super User
      7 years ago

      Anonymous can you share sample data in excel