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.
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 🙂
Join the community in Stockholm for expert Microsoft Fabric learning including a very exciting keynote from Arun Ulag, Corporate Vice President, Azure Data.
User | Count |
---|---|
87 | |
85 | |
68 | |
67 | |
64 |
User | Count |
---|---|
210 | |
118 | |
116 | |
81 | |
74 |