The ultimate Fabric, Power BI, SQL, and AI community-led learning event. Save €200 with code FABCOMM.
Get registeredCompete to become Power BI Data Viz World Champion! First round ends August 18th. Get started.
Hi,
I'd like to build a matrix table which shows following summary rows for groups and in total:
is it possible? Or something just similar?
Solved! Go to Solution.
Hi @Lesny ,
I have achieved a similar result, but the table was transposed. This method has the advantage of being relatively easy to implement.
I've made a test for your reference:
1\I assume there is a table
2\Create two measures
AVG = AVERAGE(Produce_Parameter_Data[Value])
STDEV = STDEV.P(Produce_Parameter_Data[Value])
3\Add a Matrix
Best Regards,
Bof
Hi, thanks but what you did was to transform the data but how to achieve this effect in visualisation? The table (2) from your answer I have already but how to transform this table?
User | Count |
---|---|
86 | |
84 | |
36 | |
35 | |
32 |
User | Count |
---|---|
95 | |
75 | |
66 | |
54 | |
53 |