Power Bi - Reports on Cell Colours in Excel

[Bankesy26-_]

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

[Anonymous]

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.

[MFelix · Accepted solution]

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.