Forum Discussion
Multiple Columns as Rows with Multiple Calculations of those Columns
I have some data in columns as seen below: I need this data to appear in a visual like this: I can't figure out how to make the column headers as rows and then get multiple values fr...
Hi IBrant ,
Try selecting the matrix. --> format pane -> Value --> switch values to the row --> row headers --> turn off stepped layout:
Output:
Is this your expected output?
Best Regards,
Gao
Community Support Team
If there is any post helps, then please consider Accept it as the solution to help the other members find it more quickly.
If I misunderstand your needs or you still have problems on it, please feel free to let us know. Thanks a lot!
How to get your questions answered quickly -- How to provide sample data in the Power BI Forum -- China Power BI User Group
Hi, Gao,
Thanks for your response but I need it to look more like this:
Also, I do not have a row column that inclues all of the categories like your country column. TIA