The ultimate Microsoft Fabric, Power BI, Azure AI & SQL learning event! Join us in Las Vegas from March 26-28, 2024. Use code MSCUST for a $100 discount. Register Now
Hello,
I am trying to create a report that should have exclude and include button to exclude/include email ids from certain domains. For example: I have a table that has a list of email ids from various domains, including my company's domain. So, when i click on exclude button it should exclude all internal email ids and filter all the visual to give data for external ids only. and when i click on include button then it should have all the visuals containing all the ids.
BR
Sujata
Solved! Go to Solution.
@sujatakaran , for include and include might need have table(using enter table) or some other way .
Include is the default behavior, for exclude refer to this solution. Switch the measure on including an exclude
https://community.powerbi.com/t5/Desktop/Exclude-value-via-a-slicer/td-p/467691
Create a slicer for include and exclude / switch measure slicer
make them look lik button https://docs.microsoft.com/en-us/power-bi/power-bi-slicer-filter-responsive
@sujatakaran , for include and include might need have table(using enter table) or some other way .
Include is the default behavior, for exclude refer to this solution. Switch the measure on including an exclude
https://community.powerbi.com/t5/Desktop/Exclude-value-via-a-slicer/td-p/467691
Create a slicer for include and exclude / switch measure slicer
make them look lik button https://docs.microsoft.com/en-us/power-bi/power-bi-slicer-filter-responsive
Join us at our first-ever Microsoft Fabric Community Conference, March 26-28, 2024 in Las Vegas with 100+ sessions by community experts and Microsoft engineering.
User | Count |
---|---|
158 | |
106 | |
96 | |
83 | |
75 |
User | Count |
---|---|
154 | |
137 | |
131 | |
81 | |
62 |