Power BI is turning 10! Tune in for a special live episode on July 24 with behind-the-scenes stories, product evolution highlights, and a sneak peek at what’s in store for the future.
Save the dateEnhance your career with this limited time 50% discount on Fabric and Power BI exams. Ends August 31st. Request your voucher.
Hey guys,
I've got the following revenue Matrix visualized, based on table called Source.
However I'd like to combine the revenue goals with this table. (Table called Goals)
Dragging these values into the visual doesn't work, because they are in 2 seperate tables. Result is this:
Joining the two tables in such a way that the goal is present in every line, and then using 'min' or 'max' or 'avg' values does get the correct amount per "Fonds". However the Total is not what I want. Result is this:
Any alternative way I can make this work?
With kind regards,
Lazzanova
Solved! Go to Solution.
Create a dimension table for Fonds like
Fonds Table = DISTINCT( UNION(
ALLNOBLANKROW( Source[Fonds]),
ALLNOBLANKROW( Goals[Fonds])
))
then create one-to-many relationships from the new table to both existing tables and use the column from the new table in your matrix visuals
The Goals table already is a dimensions table. But hey, your reply helped me get to the solution 😉 Thanks!
Create a dimension table for Fonds like
Fonds Table = DISTINCT( UNION(
ALLNOBLANKROW( Source[Fonds]),
ALLNOBLANKROW( Goals[Fonds])
))
then create one-to-many relationships from the new table to both existing tables and use the column from the new table in your matrix visuals
Check out the July 2025 Power BI update to learn about new features.
User | Count |
---|---|
25 | |
10 | |
7 | |
6 | |
6 |
User | Count |
---|---|
30 | |
11 | |
11 | |
10 | |
6 |