Forum Discussion
Conditional formatting from source for use in Power BI / Power query
Hello All,
I have the following problem and I hope someone has an intelligent answer 😀:
These is my main data from an Excel file. The colours are the conditional formatting/ cells which are filled.
| Jan | Feb | Mar | |
| House1 | wall | paintings | |
| House2 | roof | windows | |
| House3 | cellar | windows |
These colours give me the information, if the part is planned, finished or on hold (for our example here)
Is there a solution to get these information imported in Power BI / Power query?
I thought of setting a number in a cell, but then I will have double the matrix. Because of a lot of different people will insert parts at the Excel, so that a change maybe the title and add a sign will be hard...
| Jan | Feb | Mar | |
| House1 | wall (F) | paintings (P) | |
| House2 | roof (H) | windows (F) | |
| House3 | cellar (H) | windows (F) |
Any other ideas?
Many thanks in advance.
3 Replies
Download PBIX file with example below
Your data should be laid out in a tabular format like this, you will need a new Status column
You can then create a CF rule based on Status like this
Which will give you matrix like this
Regards
Phil
Thank you.
Yes you are right, but my origin data has a conditional formatting which shows a status and this must be imported to power bi with the best case: Without rearranging/reformatting my original data in the original file....
