The ultimate Fabric, Power BI, SQL, and AI community-led learning event. Save €200 with code FABCOMM.
Get registeredEnhance your career with this limited time 50% discount on Fabric and Power BI exams. Ends September 15. Request your voucher.
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 |
---|---|
58 | |
56 | |
53 | |
49 | |
32 |
User | Count |
---|---|
172 | |
89 | |
70 | |
46 | |
45 |