Forum Discussion
Need Intersection results when select multiple option from Slicer
Hi NavyaMounika ,
May I ask if you have gotten this issue resolved?
If it is solved, please mark the helpful reply or share your solution and accept it as solution, it will be helpful for other members of the community who have similar problems as yours to solve it faster.
Regards,
Chaithra.
Hi NavyaMounika Yes, it is possible to achieve this in Power BI by creating a measure for intersection. Use DAX to filter only accounts related to "VANILLA" entries and ensure the measure identifies common accounts across all selected tasks. Add a slicer for Task Name and link it to visuals like a Donut Chart or Table to display filtered results. Ensure proper visual interactions to make the slicer dynamically filter the accounts.
Hi,
I have created the slicer using below dax
Baseline Slicer = CALCULATETABLE(VALUES('Baseline'[Task Name]),FILTER('Baseline', 'Baseline'[Baseline] = "Vanilla"))Baseline Slicer = CALCULATETABLE(VALUES('Baseline'[Task Name]),FILTER('Baseline', 'Baseline'[Baseline] = "Vanilla"))However, If I wanted to show 2 graphs one should shows accounts which not falling under vanilla and in another graph shows the accounts which is not falling under vanilla in a same page based on above dax filtered task names.While using the task name filter using created above dax, it resulting only vanilla account in the first graph but in the second graph it is not showing non vanilla accounts.Please look in to this.Thanks in Advance!Regards,NavyaHi NavyaMounika You will need to create two measures one for slection of vanila and the other for selection for non vanila could you please try these
Vanilla Accounts = CALCULATE( DISTINCTCOUNT('Baseline'[Account]), 'Baseline'[Baseline] = "VANILLA", ALLEXCEPT('Baseline', 'Baseline'[Task Name]) )Non-Vanilla Accounts = CALCULATE( DISTINCTCOUNT('Baseline'[Account]), 'Baseline'[Baseline] <> "VANILLA", ALLEXCEPT('Baseline', 'Baseline'[Task Name]) )Now set the slicer to filter on Task Name
Hi Akash,
Thank you for your quick response.
In the above scenario we have to create 2different slicers.
Is there any option to use only one slicer to showcase my requirement.
Thanks in Advance!
Regards,
Navya
Hi NavyaMounika ,
Create two visuals where Visual 1 having Accounts for selected tasks with Baseline = "Vanilla"
- Create the visual of your choice (e.g., donut chart, bar chart).
- Select the visual and go to the Filters pane.
- Under Filters on this visual, locate the Baseline field.
Apply Basic Filtering and select only "VANILLA".
And for Visual 2 having Accounts for selected tasks where Baseline <> "VANILLA"- Create another visual of your choice.
- Select the visual and go to the Filters pane.
- Under Filters on this visual, locate the Baseline field.
Apply Basic Filtering and select all options except "VANILLA".
and now use a slicer on task name and filter the result.
If this post helps, then please consider accepting it as the solution to help other members find it faster, and give a big thumbs up.
Regards,
Chaithra E.But this will not give intersection account names part on basis of task name selection.
This is the concern area.
Please look in to this
Regards,
Navya
