Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
7 years ago
Solved

Stacked Column X Axis

I have a sheet that tracks different accounts and their expiration dates. I have a calculated column within PowerBi, that calculates if the account is to expired within 1 month, 2 month, 3 month, 4 m...
Need Help
  • TomMartens's avatar
    TomMartens
    7 years ago

    Hey,

     

    just create a new table, that contains all the possible values.

    Create a relationship between the new table (on the one side) and your existing table (on the many side), this article explains how to create relationships: https://docs.microsoft.com/en-us/power-bi/desktop-create-and-manage-relationships

     

    Use the column from the new table as axis, and make sure you enable this option "Show items with no data":

     

    Hopefully this provides what you are looking for.

     

    Regards,

    Tom

TomMartens's avatar
TomMartens
Super User
7 years ago

Hey,

 

just create a new table, that contains all the possible values.

Create a relationship between the new table (on the one side) and your existing table (on the many side), this article explains how to create relationships: https://docs.microsoft.com/en-us/power-bi/desktop-create-and-manage-relationships

 

Use the column from the new table as axis, and make sure you enable this option "Show items with no data":

 

Hopefully this provides what you are looking for.

 

Regards,

Tom