Forum Discussion
Power Bi - Reports on Cell Colours in Excel
Good afternoon all,
Hoping somebody more experienced with Power Bi can help me here as I'm still a relative newcomer to Power Bi.
Is it possible to import a spreadsheet (or even just a column) that has different coloured cells and then produce graphs based on those colours if I also have a time column?
See, the colours mean something to me (high, normal, low) so as an example I am trying to determine how many "high" (red cells) I have over two weeks?
Thanks in advance
Hi Bankesy26-_ ,
You can use condittional formatting to format your visuals, and in matrix or table you can also do it:
https://learn.microsoft.com/en-us/power-bi/create-reports/desktop-conditional-table-formatting
This allows to have flexibility in terms of what you want to show in terms of text, background, icons and werb url.
2 Replies
- MFelix
Super User
Hi Bankesy26-_ ,
You can use condittional formatting to format your visuals, and in matrix or table you can also do it:
https://learn.microsoft.com/en-us/power-bi/create-reports/desktop-conditional-table-formatting
This allows to have flexibility in terms of what you want to show in terms of text, background, icons and werb url.
Thank you MFelix
Hi, Bankesy26-_
Based on your description, I've created the following sample data:
Start by creating the following measure:
Measure = IF( SELECTEDVALUE('Table'[Number]) >= 85,"high",IF(SELECTEDVALUE('Table'[Number])>=50,"normal","low"))Create the following calculated column:
Status = IF([Number]>=85,"high",IF([Number]>=50,"normal","low"))The final result is as follows:
How to Get Your Question Answered Quickly
If it does not help, please provide more details with your desired output and pbix file without privacy information (or some sample data) .
Best Regards
Jianpeng Li
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
