Forum Discussion
Excel Colors to Power BI
Hello,
I am working with an Excel file modified by a third person, so I cannot decide its format.
This file has a column with colors, where red is bad performance, yellow is average performance, and green good performance.
I would like to know whether is possible or not for PowerBI to read this coloured column like normal data, and use that information in the report.
Is it possible?
Thank you for your time
5 Replies
- jdbuchanan71
Super User
It is not possible for PowerQuery to read the formtting of the cell, no. You would need to replicate the logic they use in excel in a conditional formatting rule in PowerBI.
Ok, but if it does not read the formatting, why would I replicate the logic?
Because I tried, and all coloured blank cells in Excel have a null statement in PowerBi, so I do not know how PowerBi would access to that information..
- jdbuchanan71
I thought you were wanting to show the same colors in the PowerBI report is the only reason I said you would need to replicate the logic.
- Syk
Resident Rockstar
Power BI can't detect the color of the cell as far as I'm aware... I would suggest to find out the criteria for the colors and then set up coditional formatting within Power BI to handle this.
