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 Cmcmahan ,

 

I assume that the current data does not contain the "missing" values, fo this reason I suggested to create a "dimension" table, we will see ...

 

Regards,

Tom

Cmcmahan's avatar
Cmcmahan
Resident Rockstar
7 years ago

You're right TomMartens. Good catch.

 

Since these categories are treated as text by the Power BI engine, it is unaware that it should make a "3 months" and a "4 months" category on its own.   The benefit of creating the new table that lists each of the possible category options is that you can set up an index column and sort by that to get the desired order of categories on the X-Axis.