cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
cbouichi Member
Member

how to convert excel background colors cells to a data table?

Hello everybody,

 

I need some help to convert a excel planning to a data table.

My main problem is to convert the background color cells to data. The color stand for different projects.

 

planning bi.JPGPlanning maaiseizoen.JPG 

Thank you guys for your affords.

1 ACCEPTED SOLUTION

Accepted Solutions
Community Support Team
Community Support Team

Re: how to convert excel background colors cells to a data table?

@cbouichi,

 

Not yet supported. Besides, you may take a look at Conditional table formatting in Power BI Desktop.

Community Support Team _ Sam Zha
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
3 REPLIES 3
Community Support Team
Community Support Team

Re: how to convert excel background colors cells to a data table?

@cbouichi,

 

You may take a look at link below.

https://answers.microsoft.com/en-us/msoffice/forum/msoffice_excel-mso_mac/converting-color-coded-cel...

Community Support Team _ Sam Zha
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
cbouichi Member
Member

Re: how to convert excel background colors cells to a data table?

Is this possible in power bi? Or is it better too work with macro's in excel?
Community Support Team
Community Support Team

Re: how to convert excel background colors cells to a data table?

@cbouichi,

 

Not yet supported. Besides, you may take a look at Conditional table formatting in Power BI Desktop.

Community Support Team _ Sam Zha
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.