Find everything you need to get certified on Fabric—skills challenges, live sessions, exam prep, role guidance, and more.
Get startedGrow your Fabric skills and prepare for the DP-600 certification exam by completing the latest Microsoft Fabric challenge.
I'm using a slicer to slice my table based on value on column A. I have a sliced table and now column B has only values x and y (other values got sliced out).
Now, I aim to create a table visualization that displays all rows from the original table where the column B value is either x or y.
How could I achieve this?
Solved! Go to Solution.
Hi @jayn123
Is this your desired output:
If so, you can achieve by doing something like as in attached file, with the help of table transformations and then relationships. Its functionality shall depend on your actual data, I usually seldom go this way, reason is if, we follow a dimensional design, most reports are achieved in a much simpler manner. But occassionaly we may have to somehow achieve the result, then attached is just one of the way.
https://drive.google.com/file/d/1UJxotHe2vawB5i-jEYju3xJHvfrtFict/view?usp=sharing
Hope it helps.
Hi @jayn123
Is this your desired output:
If so, you can achieve by doing something like as in attached file, with the help of table transformations and then relationships. Its functionality shall depend on your actual data, I usually seldom go this way, reason is if, we follow a dimensional design, most reports are achieved in a much simpler manner. But occassionaly we may have to somehow achieve the result, then attached is just one of the way.
https://drive.google.com/file/d/1UJxotHe2vawB5i-jEYju3xJHvfrtFict/view?usp=sharing
Hope it helps.
Slicers are designed to filter your data and hence your visuals. You want to show the opposite (things that are left after the filter). This article I wrote a few years ago is not exactly what you need, but it may help you
https://exceleratorbi.com.au/items-not-selected-slicer/
I'm sorry, perhaps I mis-phrased myself. I don't want to show whats left out of slicer. I wanna filter/re-slice based on the results of the original slicing.
I have table:
A | B | C
1 x i8
1 y i12
2 z i10
2 q i41
2 x i99
3 y i88
If I slice A=1, I get B values x and y. Now I wan't to filter/re-slice by B values x and y, so that I have following rows as result:
A | B | C
1 x i8
1 y i12
2 x i99
3 y i88
Hi,
Given this table in which A has 2 types - Type 1 and Type 2, the result (second image) wll show all those rows in the Table visual, which have the type as 1 and 2.
Hope this helps.
PBI file attached.
Hi,
Why do you not just straight away apply a filter on x and y?
Then add a second slicer for column B
I can't apply slicer nor filter to Column B, because I do not know what values I should filter. X and y were just examples to clarify what I'm trying to achieve. I only know what I wanna slice by Column A.
User | Count |
---|---|
77 | |
77 | |
68 | |
67 | |
49 |
User | Count |
---|---|
108 | |
105 | |
93 | |
83 | |
64 |