Forum Discussion
HansBroecker
9 months agoNew Member
Newbie Question for the Filter
Hi all, i have a newbie question A Column called “Cat” contains 4 elements TaskA, TaskB, TasksC and TaskD I want to create a summary sheet on one sheet The header should be displayed us...
- 9 months ago
You can follw folling given below steps:
Insert four Card visuals.
For each card:
Select the card.
Go to Filters pane → Visual level filters.
Add the column Cat into the filter area.
Set the filter:
Card 1: Cat = TaskA
Card 2: Cat = TaskB
Card 3: Cat = TaskC
Card 4: Cat = TaskD
Make sure:
No Page filter is applied to Cat.
No Report filter applied to Cat.
This makes each card independent from page filters.
Idrissshatila
9 months agoSuper User
Hello HansBroecker ,
as amitchandak mentioned this works, or you can have the measure in 4 cards the same and filter each one of them in the filter pane this works as well.
or you can make 4 measures filtering in the dax where cat = "TaskA".
All of them works.