Join us for an expert-led overview of the tools and concepts you'll need to pass exam PL-300. The first session starts on June 11th. See you there!
Get registeredPower BI is turning 10! Let’s celebrate together with dataviz contests, interactive sessions, and giveaways. Register now.
Dear great cummunity,
i have Country1, Country2, Country3
and beside each column one column for the number of individual
i need to disply them in multi-row card as one value without duplication
is there a way to do so?
Solved! Go to Solution.
Hi @NourJ ,
There are two solutions. Please download the demo from the attachment.
1. Transform the data using M.
Result = Table.Combine({Table.RenameColumns(Table.SelectColumns(#"Changed Type", {"Col1", "Value1"}), {{"Col1", "Col"}, {"Value1", "Value"}}),
Table.RenameColumns(Table.SelectColumns(#"Changed Type", {"Col2", "Value2"}), {{"Col2", "Col"}, {"Value2", "Value"}}),
Table.RenameColumns(Table.SelectColumns(#"Changed Type", {"Col3", "Value3"}), {{"Col3", "Col"}, {"Value3", "Value"}})})
2. Create a new table and establish three relationships.
Cols = FILTER ( DISTINCT ( UNION ( VALUES ( Table2[Col1] ), VALUES ( Table2[Col2] ), VALUES ( Table2[Col3] ) ) ), [Col1] <> BLANK () )
Measure = SUM ( Table2[Value1] ) + CALCULATE ( SUM ( Table2[Value2] ), USERELATIONSHIP ( Cols[Col1], Table2[Col2] ) ) + CALCULATE ( SUM ( Table2[Value3] ), USERELATIONSHIP ( Cols[Col1], Table2[Col3] ) )
Best Regards,
UNION the VALUES of your columns together and then do a DISTINCT perhaps.
@Greg_Decklerhow i can union them, i forgot to mention that this data is being updated mothly. so how can i union them ? is there a formula to do it or i had to add extra table manualy?
Hi @NourJ ,
Can you post the expected result based on your snapshot, please? Would like the unique value in a column or unioning the three columns?
Best Regards,
This is the result that i want to get, i want to have a column have the value of the three columns to usein slicer and in the multi-row card. this picture from old data, at that time i have it in one column while now i have to update my dashboard in the same visualization but the source of data have changed to three columns.
is it possible to have it like the attached pic?!
Hi @NourJ ,
There are two solutions. Please download the demo from the attachment.
1. Transform the data using M.
Result = Table.Combine({Table.RenameColumns(Table.SelectColumns(#"Changed Type", {"Col1", "Value1"}), {{"Col1", "Col"}, {"Value1", "Value"}}),
Table.RenameColumns(Table.SelectColumns(#"Changed Type", {"Col2", "Value2"}), {{"Col2", "Col"}, {"Value2", "Value"}}),
Table.RenameColumns(Table.SelectColumns(#"Changed Type", {"Col3", "Value3"}), {{"Col3", "Col"}, {"Value3", "Value"}})})
2. Create a new table and establish three relationships.
Cols = FILTER ( DISTINCT ( UNION ( VALUES ( Table2[Col1] ), VALUES ( Table2[Col2] ), VALUES ( Table2[Col3] ) ) ), [Col1] <> BLANK () )
Measure = SUM ( Table2[Value1] ) + CALCULATE ( SUM ( Table2[Value2] ), USERELATIONSHIP ( Cols[Col1], Table2[Col2] ) ) + CALCULATE ( SUM ( Table2[Value3] ), USERELATIONSHIP ( Cols[Col1], Table2[Col3] ) )
Best Regards,
This is your chance to engage directly with the engineering team behind Fabric and Power BI. Share your experiences and shape the future.
Check out the June 2025 Power BI update to learn about new features.
User | Count |
---|---|
78 | |
76 | |
53 | |
37 | |
31 |
User | Count |
---|---|
101 | |
56 | |
51 | |
45 | |
40 |