Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.
Hi @Zzema,
I don't think matrix column will support for these values.
In my opinion, I'd like to suggest you click enter to query editor use "unpivot table" function to convert query, then save change and use matrix work on the new table.
Steps:
1. Click on query editor.
2. Right click on current query and choose the reference function.
3. Navigate to referenced query, choose these value column and click on "unpivot table" button.(transform tab -> unpivot table)
Regards,
Xiaoxin Sheng
Hi @Zzema,
You can simply switch the column field order and turn on the grid to achieve your requirement:
Regards,
Xiaoxin Sheng
@v-shex-msft HI. Very glad to see you answer. But my fields (traffic, orders,revenue etc) is not columns, its a values.
Is this a solvable problem?
Hi @Zzema,
I don't think matrix column will support for these values.
In my opinion, I'd like to suggest you click enter to query editor use "unpivot table" function to convert query, then save change and use matrix work on the new table.
Steps:
1. Click on query editor.
2. Right click on current query and choose the reference function.
3. Navigate to referenced query, choose these value column and click on "unpivot table" button.(transform tab -> unpivot table)
Regards,
Xiaoxin Sheng
Anybody now, how decide this problem?
Or maybe someone know, how I can brushed different grids (borders). But change the level of the column name of the date and the name of the fields used is more important
Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City
Check out the April 2024 Power BI update to learn about new features.
User | Count |
---|---|
58 | |
20 | |
19 | |
18 | |
9 |