Forum Discussion
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 using the visuals “card”
TaskA TaskB TasksC TaskD
But I am only to show one per card, like
TaskA TaskA TasksA TaskA
etc
How can I change this (that the filter does not work for the whole page)
Thanks a lot
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.
4 Replies
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.
This is a more appropriate way to do this.
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.
