Displaying run out on Power BI?

[samanthamirae]

Hi everyone,

I am trying to display something very similar like this on Power BI but I'm not quite sure if it's possible. Does anyone have any suggestions on where I may be able to start? This chart shows when a certain part inventory is projected to run out.

Thank you!

[Anonymous · Accepted solution]

Hi @samanthamirae

You can use the conditional formatting.

Click on the Table/ Matrix visual -> Go to Visualizations- > Go to Format Tab -> Conditional Formatting, Check Background colur 'ON', Make sure you select the Inventory measure in the dropdown there. Click on the Advance Controls - > Select colour by rules, set the colour as needed there.

Thanks

Raj

[samanthamirae]

Thank you for helping! I am running into one more issue. As you can see in the screenshot, PBI is only letting me apply color to "Device + Board/Strategy" and not the actual numbers of each month. Also, if I want to add the conditional formatting to every cell like the Excel screenshot above, will I have to manually select conditional formatting for every column? Is there an easier way to do this?

Thank you. I am still new to Power BI.

[Anonymous]

As i mentioend earleir, you need to select the field in Format page before you go to advanced controls. I have highlighted below the place where you need to do this.

 

Thanks
Raj

[samanthamirae]

Hey,

Sorry I figured that part out. The last thing I am wondering is if I am able to apply conditional formatting on all my month and quarter columns at once? Because as of now, I have to type and apply the conditional formatting for every column (month/Quarter) separately which is very inefficient now and in the future.

I appreciate the help!

[Anonymous]

I am afraid that we dont have the option to do it in one shot for all columns.Conditional formatting is applicable to column level, so each column should be selected individually to format.

Thanks
Raj