Forum Discussion
Excel Colors to Power BI
Super UserIt 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.
V-lianl-msftCommunity Support
Hi nachoroncero ,
Do you want to add a background color to the data in the table visual in power bi?
If so, Please try to set conditional formatting.
Please refer to:
https://docs.microsoft.com/en-us/power-bi/create-reports/desktop-conditional-table-formatting
Best Regards,
Liang
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.