Join us for an expert-led overview of the tools and concepts you'll need to pass exam PL-300. The first session starts on June 11th. See you there!
Get registeredPower BI is turning 10! Let’s celebrate together with dataviz contests, interactive sessions, and giveaways. Register now.
Hello - I'm trying to understand how the top left most cell is populated on a matrix visual when you have both column and row values. It seems to display the name of the rows field, but formats itself to match the columns which is confusing to the report user. See example below.
I am looking for either a way to have it display the field name that is in the columns value location or a way to format it to match the row header formatting. Kind of like this:
Thanks for any insight you can provide.
Hi @Anonymous
There is no such option in power bi currently, you could distinguish the "row" and "column" with a workaround as below.
create a column in the table
rwo/column = "column"
then add "row/column" in the "Column" field, and click on the "expand" icon on the top-right of the matrix.
Best Regards
Maggie
User | Count |
---|---|
84 | |
76 | |
74 | |
49 | |
39 |
User | Count |
---|---|
114 | |
56 | |
51 | |
42 | |
42 |