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,
I am trying to rebuild an Excel table in a Power BI visual (Matrix Table). But I am facing an issue with the non grouped values. The total value, stock and overdues are the current situation and not to be included in the month columns.
The Excel table I would like to build in Power BI.
(Different measures are used to calculate the values in the table.)
My current result in Power BI
The total (kg); Stock Qty and Overdue Qty should be in a separate group and not included in the monthly groups.
Anyone an idea? A different visual? A DAX trick?
Thx!
Thanks for the replies guys! I hope MS brings us a solution soon. For now I will use two different tables.
(I will vote for your idea's.)
Hi @Anonymous ,
Power BI doesn't support it currently. You could vote for the following ideas to improve Power BI and make this feature coming sooner.
I do not this is possible unless there is custom visual available. I create an idea for this, please vote for that
https://ideas.powerbi.com/forums/265200-power-bi-ideas/suggestions/39773011-hybrid-table
Hello @Anonymous ,
I do not think that any native visual in Power BI supports this.
You may alternatively try creating two separate visuals (a combination of a table and a matrix visual).
Cheers!
Vivek
If it helps, please mark it as a solution
Kudos would be a cherry on the top 🙂
https://www.vivran.in/
Connect on LinkedIn
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 |
---|---|
104 | |
95 | |
80 | |
67 | |
62 |
User | Count |
---|---|
147 | |
109 | |
107 | |
85 | |
63 |