Solved: Proper visual for below data

veeramahesh · ‎03-13-2024

Hi All,

Thanks in Advance,

I need visual like below but please note column order shuold be same.

Source Data

Expceted visual,

but column order should be in same order.

@amitchandak @Daniel29195

Thank you,

Ritaf1983 · ‎03-13-2024

Hi @veeramahesh
We don't have the option to "merge and center" cells like Excel.
So the closest visual to the request that you can achieve it :

if it helps you can follow my steps (in PQ + DAX) , I attached a pbix.

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

Regards,
Rita Fainshtein | Microsoft MVP
https://www.linkedin.com/in/rita-fainshtein/
Blog : https://www.madeiradata.com/profile/ritaf/profile

View solution in original post

Ritaf1983 · ‎03-13-2024

Hi @veeramahesh
We don't have the option to "merge and center" cells like Excel.
So the closest visual to the request that you can achieve it :

if it helps you can follow my steps (in PQ + DAX) , I attached a pbix.

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

Regards,
Rita Fainshtein | Microsoft MVP
https://www.linkedin.com/in/rita-fainshtein/
Blog : https://www.madeiradata.com/profile/ritaf/profile

AmiraBedh · ‎03-13-2024

Excel is not Power BI. I don't think you can achieve this.

Proud to be a Power BI Super User !

Microsoft Community : https://docs.microsoft.com/en-us/users/AmiraBedhiafi
Linkedin : https://www.linkedin.com/in/amira-bedhiafi/
StackOverflow : https://stackoverflow.com/users/9517769/amira-bedhiafi
C-Sharp Corner : https://www.c-sharpcorner.com/members/amira-bedhiafi
Power BI Community :https://community.powerbi.com/t5/user/viewprofilepage/user-id/332696