Forum Discussion
Solved
Data Format in Power BI Query Editor
Hello All,
I have a very simple data format requirement, but I am facing a challenge in Power BI to achieve it. Please find the details below.
Table A:
| Fruits Category | Fruits Name | Fruits Color |
| Organic | Apple | Red |
| Organic | Apple | Green |
| Organic | Banana | Green |
| Organi | Grapes | Green |
| Non Organic | Apple | Red |
| Non Organic | Apple | Green |
| Non Organic | Banana | Green |
| Non Organic | Grapes | Green |
Below is the Data Output Data Format I am trying
| Fruits Category | Fruits Name | Fruits Color |
| Organic | ||
| Organic | Apple | Red |
| Organic | Apple | Green |
| Organic | Banana | Green |
| Organi | Grapes | Green |
| Non Organic | ||
| Non Organic | Apple | Red |
| Non Organic | Apple | Green |
| Non Organic | Banana | Green |
| Non Organic | Grapes | Green |
Appreciate all your help!!!
Note: Color is not mandatory...
Power Query does not support any coloring of data.
2 Replies
Power Query does not support any coloring of data.
Hi PowerBI159 ,
To achieve your goal, it should be matrix style and you need to serialize it for your data, otherwise power bi will automatically aggregate it.
Hope it helps!
Best regards,
Community Support Team_ Scott ChangIf this post helps then please consider Accept it as the solution to help the other members find it more quickly.
