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, here is the data
I swithed the rows into values in matrix:
but the visual should be like this, a summary of top 3 months should be added
so how to add such a summary value in rows? Thank you.
Hi @Anonymous
Thanks for reaching out to us.
I just want to confirm if you resolved this issue? If yes, you can accept the answer helpful as the solution or share you method and accept it as solution, thanks for your contribution to improve Power BI.
If you need more help, please let me know.
Best Regards,
Community Support Team _Tang
If this post helps, please consider Accept it as the solution to help the other members find it more quickly.
Hi @Anonymous,
Not sure I understood the question properly, but have you tried turning on row and column subtotals on the matrix?
Thank you,
Vishesh Jain
Proud to be a Super User!
Thanks, it's a summary of a certain values rather the total of all values
Hi @Anonymous,
Please have a look at the following video, this should answer your question.
Computing totals by summing visible values in DAX - YouTube
You can use the same concept and change the measure only for the total line.
Thank you,
Vishesh Jain
Proud to be a Super User!
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 |
---|---|
106 | |
98 | |
80 | |
67 | |
63 |
User | Count |
---|---|
145 | |
111 | |
104 | |
84 | |
64 |