Check your eligibility for this 50% exam voucher offer and join us for free live learning sessions to get prepared for Exam DP-700.
Get StartedDon't miss out! 2025 Microsoft Fabric Community Conference, March 31 - April 2, Las Vegas, Nevada. Use code MSCUST for a $150 discount. Prices go up February 11th. Register now.
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 🙂
March 31 - April 2, 2025, in Las Vegas, Nevada. Use code MSCUST for a $150 discount! Prices go up Feb. 11th.
Check out the January 2025 Power BI update to learn about new features in Reporting, Modeling, and Data Connectivity.
User | Count |
---|---|
143 | |
77 | |
63 | |
51 | |
47 |
User | Count |
---|---|
212 | |
82 | |
61 | |
60 | |
57 |