Hi,
Need help to create the logic for report creation. Above status column value is taken from separte table.There is no relation between them.
My requirement is if i click on include,all values to be shown...if i click on exclude ,aa and bb values need to remove only cc row should be there.
Is it possible?
Solved! Go to Solution.
Hi @NISHA_S ,
This is not a perfect solution but it presents the data you want:
Create 2 calculated columns:
Include = 1
Exclude =
if(
'Table'[Values] = "cc",
1,
blank()
)
After, create a Field parameter with both columns:
Drag the parameter to a slicer and to the column field of your visual
By selecting exclude only the cc is marked as "1"
By selecting include all are marked as 1
Sample file attached:)
Hope I was of assistance!
Cheers
Joao Marcelino
Ps- Did I answer your question? Mark my post as a solution! Kudos are also appreciated 🙂
Hi @NISHA_S ,
This is not a perfect solution but it presents the data you want:
Create 2 calculated columns:
Include = 1
Exclude =
if(
'Table'[Values] = "cc",
1,
blank()
)
After, create a Field parameter with both columns:
Drag the parameter to a slicer and to the column field of your visual
By selecting exclude only the cc is marked as "1"
By selecting include all are marked as 1
Sample file attached:)
Hope I was of assistance!
Cheers
Joao Marcelino
Ps- Did I answer your question? Mark my post as a solution! Kudos are also appreciated 🙂
User | Count |
---|---|
110 | |
63 | |
60 | |
37 | |
37 |
User | Count |
---|---|
118 | |
65 | |
65 | |
64 | |
50 |