Forum Discussion
Extract/Pull Data from Excel document along with the cell colors in to power bi dashboard
Hi Team,
We have a requirement to pull/extract the data from excel doc along with the cell colors into power bi dash board as it is in excel doc also it should change dynamically whenever the user changes the cell colors in the source excel doc. can this be doable . please suggest the process.
Thanks & rgerads,
Sravani
Hi Anonymous ,
When you pull the data into Power BI, you are pulling the data and not the formatting. So, natively, no, you can not pull in the color. However, what you could do is recreate the formula in Power BI so that it does the conditional color formatting. If there is not a formula and it is just the user highlighting a field then I would suggest adding another column to Excel (call it "color" or whatever you need) and then you can use that field as your conditional format field in Power BI. (ie. if the color field in Excel is "blue" then in you conditional formatting you use the "color column" to format the "data column").
1 Reply
- collinq
Super User
Hi Anonymous ,
When you pull the data into Power BI, you are pulling the data and not the formatting. So, natively, no, you can not pull in the color. However, what you could do is recreate the formula in Power BI so that it does the conditional color formatting. If there is not a formula and it is just the user highlighting a field then I would suggest adding another column to Excel (call it "color" or whatever you need) and then you can use that field as your conditional format field in Power BI. (ie. if the color field in Excel is "blue" then in you conditional formatting you use the "color column" to format the "data column").