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.
Hello Community,
I have once again a requirement from my stakeholders that I just dont know how to deal with. It is a combination of a table and matrix table. I can see the added value of such a visualization. I see that there is no way to do that in power bi. Do you happen to have an idea anyway?
Hier is an example of the wanted output:
This is how the input sort of looks like.
Solved! Go to Solution.
@raymondpocher , You need a hybrid table, which is not supported as of now
if you are looking for a Hybrid display with Matrix Column and measure
https://community.powerbi.com/t5/Community-Blog/Creating-a-custom-or-hybrid-matrix-in-PowerBI/ba-p/1...
https://community.powerbi.com/t5/Quick-Measures-Gallery/The-New-Hotness-Custom-Matrix-Hierarchy/m-p/...
vote for Hybrid Table
https://ideas.powerbi.com/ideas/idea/?ideaid=9bc32b23-1eb1-4e74-8b34-349887b37ebc
Thanks everyone!
@amitchandak I have found your solution link to be best. Yet it is a pretty time consuming process. It would be great if Power BI integrates that as a standard. So I have voted for it.
If you holy power bi are reading this, please add it as a new feature soon!
Please see this article (the 2nd part on Calculations Groups) for how to do this.
Building a Matrix with Asymmetrical Columns and Rows in Power BI - Excelerator BI
Pat
To learn more about Power BI, follow me on Twitter or subscribe on YouTube.
@raymondpocher , You need a hybrid table, which is not supported as of now
if you are looking for a Hybrid display with Matrix Column and measure
https://community.powerbi.com/t5/Community-Blog/Creating-a-custom-or-hybrid-matrix-in-PowerBI/ba-p/1...
https://community.powerbi.com/t5/Quick-Measures-Gallery/The-New-Hotness-Custom-Matrix-Hierarchy/m-p/...
vote for Hybrid Table
https://ideas.powerbi.com/ideas/idea/?ideaid=9bc32b23-1eb1-4e74-8b34-349887b37ebc
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 |
---|---|
114 | |
99 | |
83 | |
70 | |
60 |
User | Count |
---|---|
150 | |
115 | |
104 | |
89 | |
65 |