Data Format in Power BI Query Editor

[PowerBI159]

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...

[Anonymous]

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 Chang

If this post helps then please consider Accept it as the solution to help the other members find it more quickly.

[lbendlin · Accepted solution]

Power Query does not support any coloring of data.