Forum Discussion

gmat's avatar
gmat
Icon for Helper I rankHelper I
2 years ago
Solved

Displaying 0s in Summary Matrix Not Working Correctly

I'm currently working on a summary dashboard in PowerBI that displays data from two business units over the last 12 months. I've divided the dashboard into sections, with the first section focusing o...
Need Help
lbendlin's avatar
lbendlin
Icon for Super User rankSuper User
2 years ago

To report on things that are not there you need to use disconnected tables and crossjoins.  In your scenario you need a disconnected calendar table for your X axis.

  • gmat's avatar
    gmat
    Icon for Helper I rankHelper I
    2 years ago

    I get the idea here but I am unable to use a disconnected calendar table for my x axis. PowerBI canot use the calendar table without a relationship.

     

     

    • lbendlin's avatar
      lbendlin
      Icon for Super User rankSuper User
      2 years ago

      you can use two calendar tables. One for the data model and one for the X axis.

      • gmat's avatar
        gmat
        Icon for Helper I rankHelper I
        2 years ago

        Can you walk me through how to do this? Not sure I know how to.