Microsoft Fabric Community Conference 2025, March 31 - April 2, Las Vegas, Nevada. Use code FABINSIDER for a $400 discount.
Register nowGet inspired! Check out the entries from the Power BI DataViz World Championships preliminary rounds and give kudos to your favorites. View the vizzies.
Hi,
I've created a Matrix table like the below:
For the total column marked in red, is it possible to use these figures in another table?
I want to take these figures, and then do a count of how many are showing:
Thanks in advanced!
Solved! Go to Solution.
@hdemedici100 totals are just presented on this visual, they are not physically stored anywhere. If you group data by some other column, these totals will be different.
In order to make it work, you would need to create table in expected format (columns used in rows + measure). You can make it using summarize function in dax, or to use GroupBy option in Power Query.
And then add new column using if or switch statement which says in which range each row fits.
Then it is easy to show results in visual.
Cheers,
Nemanja Andic
@hdemedici100 totals are just presented on this visual, they are not physically stored anywhere. If you group data by some other column, these totals will be different.
In order to make it work, you would need to create table in expected format (columns used in rows + measure). You can make it using summarize function in dax, or to use GroupBy option in Power Query.
And then add new column using if or switch statement which says in which range each row fits.
Then it is easy to show results in visual.
Cheers,
Nemanja Andic
Hi Nemanja,
Thanks very much for responding and for explaining. I didn't realise this was the case with the Matrix visual.
I'll look to reproduce it in a new table, and see how I get on. If I get stuck, I'll come back to this forum.
Harry
March 31 - April 2, 2025, in Las Vegas, Nevada. Use code FABINSIDER for a $400 discount!
Check out the February 2025 Power BI update to learn about new features.
User | Count |
---|---|
85 | |
75 | |
65 | |
51 | |
30 |
User | Count |
---|---|
115 | |
109 | |
71 | |
65 | |
39 |