Get certified in Microsoft Fabric—for free! For a limited time, the Microsoft Fabric Community team will be offering free DP-600 exam vouchers. Prepare now
Column 1 | Column 2 | Flag |
A | B | 1 |
B | C | 1 |
D | A | 1 |
E | D | 1 |
I have a table like this. I am able to filter the table by both the columns using a measure. For example, the output table for a filter on both columns 1 and 2 for 'B' looks like this
Column 1 | Column 2 | Flag |
A | B | 1 |
B | C | 1 |
I want a visual that displays only Column 1 and Flag in a Matrix form. The visual I get at the moment
Column 1 | Flag |
B | 1 |
However, I want my visual to look like below
Column 1 | Flag |
A | 1 |
B | 1 |
Can somebody please help?
Solved! Go to Solution.
Assuming you have a Disconnected Table with values in both Column 1 and Column 2. If you have that already, good, other wise, you can create that like with a New Calculated Table like this:
Add the column from your disconnected slicer to the Filters Pane.
Then create a Measure for your flag as below
FlagDisplay =
CALCULATE (
SUM ( 'MyTable'[Flag] ),
KEEPFILTERS (
'MyTable'[Column1]
IN VALUES ( CombinedValues[Slice] )
|| 'MyTable'[Column2] IN VALUES ( CombinedValues[Slice] )
)
)
If this works for you, please mark it as a solution so it can be found easily by anyone who may have similar issues.
Assuming you have a Disconnected Table with values in both Column 1 and Column 2. If you have that already, good, other wise, you can create that like with a New Calculated Table like this:
Add the column from your disconnected slicer to the Filters Pane.
Then create a Measure for your flag as below
FlagDisplay =
CALCULATE (
SUM ( 'MyTable'[Flag] ),
KEEPFILTERS (
'MyTable'[Column1]
IN VALUES ( CombinedValues[Slice] )
|| 'MyTable'[Column2] IN VALUES ( CombinedValues[Slice] )
)
)
If this works for you, please mark it as a solution so it can be found easily by anyone who may have similar issues.
It works, thank you
Hi,
In this case I suggest you use a calculated column with the following formula:
that's what I have in the 2nd table. I want a visual table that doesn't include Column 2 but still gives me all rows filtered in Column 1
Yes, please try to follow my suggestion and don't add the second column, it will work 😊
yes but this is dynamic, I want it to filter based on a Slicer
Is "flag" a numeric column?
yes
How many slicers do you have ?and what are all the columns you are using?
Thanks,
Arul
just one slicer which has combined values of both column 1 and column 2.
Check out the October 2024 Power BI update to learn about new features.
Learn from experts, get hands-on experience, and win awesome prizes.
User | Count |
---|---|
113 | |
96 | |
92 | |
87 | |
69 |
User | Count |
---|---|
161 | |
126 | |
119 | |
109 | |
95 |