Forum Discussion

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

Cmcmahan

Resident Rockstar

7 years ago

If you click the dropdown arrow on your axis field (Expiration in your case) you should see an option to Display Items with no data. Selecting this will show you the expected blanks for month 3 & month 4.

After that, it's all about ordering your graph by X-Axis category. It should be easy to get 1-7 months in order, with expired after 7, since that's alphabetical order. If you want expired first, you'll need to set up an ordering column that indicates what order the categories should be sorted in and use that.

TomMartens