Need Intersection results when select multiple option from Slicer

[NavyaMounika]

Hi All,

I have a dataset which contains multiple columns in which i have to focus only on 3 column basically which have been listed here Account, Task Name and Baseline. Below is the sample data. In baseline column there are few entries of custom and "-" entries. I have to show task name in slicer that slicer also should filter based on only vanilla entries in one graph and in another should show accounts where vanilla is not existing.These both graphs should interact with single task name slicer.

I have to show only distinct account names in donut chart or any other graph where in common account name existing in all selected task names from the slicer.

For Example:

If I filter on " Backup Client Software Upgrade" this task name, accounts ACC3,ACC4,ACC5,ACC7 should display

If I filter on "Backup Job Failure Report" this task name, accounts ACC2,ACC3,ACC5,ACC6,ACC7 should display

If I filter on both " Backup Client Software Upgrade & Backup Job Failure Report" these task names, then ACC3,ACC5,ACC7 should display in result

If I filter on " Backup Client Software Upgrade, Daily replication check for backup data & Backup Job Failure Report" these task names, then ACC3,ACC5,ACC7

If I filter on " Backup Client Software Upgrade& Daily replication check for backup data" these task names, then ACC3,ACC4,ACC5,ACC7 should display in resultant graph.

Account Task Name Baseline
ACC7 Daily replication check for backup data VANILLA
ACC7 Backup Job Failure Report VANILLA
ACC7 Backup Job Success Report VANILLA
ACC7 Backup Media Cleanup VANILLA
ACC4 Daily Backup Status Report VANILLA
ACC4 Daily Backup Status Report VANILLA
ACC4 Daily Backup Status Report VANILLA
ACC4 Daily Backup Status Report VANILLA
ACC4 Daily Backup Status Report VANILLA
ACC4 Monthly Backup Status Report VANILLA
ACC4 Monthly Backup Status Report VANILLA
ACC4 Monthly Backup Status Report VANILLA
ACC4 Monthly Backup Status Report VANILLA
ACC4 Daily Backup Status Report VANILLA
ACC3 Backup Job Success Report VANILLA
ACC3 Backup Media Cleanup VANILLA
ACC3 Daily Backup Status Report VANILLA
ACC3 Daily Backup Status Report VANILLA
ACC3 Daily Backup Status Report VANILLA
ACC3 Daily replication check for backup data VANILLA
ACC3 Daily Backup Status Report VANILLA
ACC2 Backup Job Success Report VANILLA
ACC2 Backup License Utilization Report VANILLA
ACC1 Daily Backup Status Report VANILLA
ACC1 DR_sync report for Isilon cluster VANILLA
ACC1 Daily Backup Status Report VANILLA
ACC1 Backup Drive Threshold Report VANILLA
ACC5 Backup Media Cleanup VANILLA
ACC5 Daily replication check for backup data VANILLA
ACC5 Backup Job Success Report VANILLA
ACC2 Daily replication check for backup data VANILLA
ACC7 Transfer and Install the Backup SW agent VANILLA
ACC7 Backup License Utilization Report VANILLA
ACC7 Backup Client Software Upgrade VANILLA
ACC7 Backup Library Space utilization VANILLA
ACC3 Backup License Utilization Report VANILLA
ACC3 Backup Job Failure Report VANILLA
ACC3 Backup Client Software Upgrade VANILLA
ACC3 Commserv Anomaly Alert VANILLA
ACC3 Transfer and Install the Backup SW agent VANILLA
ACC3 Backup Library Space utilization VANILLA
ACC2 Backup Job Failure Report VANILLA
ACC2 Backup Library Space utilization CUSTOM
ACC5 Backup Job Failure Report CUSTOM
ACC5 Backup License Utilization Report CUSTOM
ACC5 Commserv Anomaly Alert CUSTOM
ACC2 Transfer and Install the Backup SW agent CUSTOM
ACC5 Transfer and Install the Backup SW agent CUSTOM
ACC5 Backup Client Software Upgrade CUSTOM
ACC5 Backup Library Space utilization CUSTOM
ACC6 Data Domain Utilization report CUSTOM
ACC6 Backup Job Failure Report-
ACC6 Backup Replication Report-
ACC6 Successfully Backup Jobs Report-
ACC6 No Backup Report-
ACC6 Device went offline-
ACC4 Transfer and Install the Backup SW agent-
ACC4 Daily replication check for backup data-
ACC1 Daily replication check for backup data-
ACC4 Backup Client Software Upgrade CUSTOM

Please help me with the resolution on this scenario. Looking forward for your help to resolve this problem.

Thanks,

Navya

[v-echaithra · Accepted solution]

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.

[v-echaithra]

Hi @NavyaMounika ,

As we haven’t heard back from you, we wanted to kindly follow up to check if the solution provided for the issue worked? or Let us know if you need any further assistance?
If our response addressed, please mark it as Accept as solution and click Yes if you found it helpful.

Regards,
Chaithra.

[v-echaithra]

Hi @NavyaMounika ,

Please explain me on what basis you want to get the below results, so that it would be easy for me to work on the result:

Filtering on both " Backup Client Software Upgrade & Backup Job Failure Report" these task names, then ACC3,ACC5,ACC7 should display in result

Filtering on " Backup Client Software Upgrade, Daily replication check for backup data & Backup Job Failure Report" these task names, then ACC3,ACC5,ACC7

Filtering on " Backup Client Software Upgrade& Daily replication check for backup data" these task names, then ACC3,ACC4,ACC5,ACC7 should display in resultant graph.

Regards,
Chaithra

[v-echaithra]

Hii @NavyaMounika ,

Can you please try to share the sample output on your requirement in excel or sample .pbix file.

Regards,
Chaithra.

[NavyaMounika]

Hi Chaitra,

For Example:

If I filter on " Backup Client Software Upgrade" this task name, accounts ACC3,ACC4,ACC5,ACC7 should display

If I filter on "Backup Job Failure Report" this task name, accounts ACC2,ACC3,ACC5,ACC6,ACC7 should display

If I filter on both " Backup Client Software Upgrade & Backup Job Failure Report" these task names, then ACC3,ACC5,ACC7 should display in result

If I filter on " Backup Client Software Upgrade, Daily replication check for backup data & Backup Job Failure Report" these task names, then ACC3,ACC5,ACC7

If I filter on " Backup Client Software Upgrade& Daily replication check for backup data" these task names, then ACC3,ACC4,ACC5,ACC7 should display in resultant graph.

Account Task Name Baseline
ACC7 Daily replication check for backup data VANILLA
ACC7 Backup Job Failure Report VANILLA
ACC7 Backup Job Success Report VANILLA
ACC7 Backup Media Cleanup VANILLA
ACC4 Daily Backup Status Report VANILLA
ACC4 Daily Backup Status Report VANILLA
ACC4 Daily Backup Status Report VANILLA
ACC4 Daily Backup Status Report VANILLA
ACC4 Daily Backup Status Report VANILLA
ACC4 Monthly Backup Status Report VANILLA
ACC4 Monthly Backup Status Report VANILLA
ACC4 Monthly Backup Status Report VANILLA
ACC4 Monthly Backup Status Report VANILLA
ACC4 Daily Backup Status Report VANILLA
ACC3 Backup Job Success Report VANILLA
ACC3 Backup Media Cleanup VANILLA
ACC3 Daily Backup Status Report VANILLA
ACC3 Daily Backup Status Report VANILLA
ACC3 Daily Backup Status Report VANILLA
ACC3 Daily replication check for backup data VANILLA
ACC3 Daily Backup Status Report VANILLA
ACC2 Backup Job Success Report VANILLA
ACC2 Backup License Utilization Report VANILLA
ACC1 Daily Backup Status Report VANILLA
ACC1 DR_sync report for Isilon cluster VANILLA
ACC1 Daily Backup Status Report VANILLA
ACC1 Backup Drive Threshold Report VANILLA
ACC5 Backup Media Cleanup VANILLA
ACC5 Daily replication check for backup data VANILLA
ACC5 Backup Job Success Report VANILLA
ACC2 Daily replication check for backup data VANILLA
ACC7 Transfer and Install the Backup SW agent VANILLA
ACC7 Backup License Utilization Report VANILLA
ACC7 Backup Client Software Upgrade VANILLA
ACC7 Backup Library Space utilization VANILLA
ACC3 Backup License Utilization Report VANILLA
ACC3 Backup Job Failure Report VANILLA
ACC3 Backup Client Software Upgrade VANILLA
ACC3 Commserv Anomaly Alert VANILLA
ACC3 Transfer and Install the Backup SW agent VANILLA
ACC3 Backup Library Space utilization VANILLA
ACC2 Backup Job Failure Report VANILLA
ACC2 Backup Library Space utilization CUSTOM
ACC5 Backup Job Failure Report CUSTOM
ACC5 Backup License Utilization Report CUSTOM
ACC5 Commserv Anomaly Alert CUSTOM
ACC2 Transfer and Install the Backup SW agent CUSTOM
ACC5 Transfer and Install the Backup SW agent CUSTOM
ACC5 Backup Client Software Upgrade CUSTOM
ACC5 Backup Library Space utilization CUSTOM
ACC6 Data Domain Utilization report CUSTOM
ACC6 Backup Job Failure Report-
ACC6 Backup Replication Report-
ACC6 Successfully Backup Jobs Report-
ACC6 No Backup Report-
ACC6 Device went offline-
ACC4 Transfer and Install the Backup SW agent-
ACC4 Daily replication check for backup data-
ACC1 Daily replication check for backup data-
ACC4 Backup Client Software Upgrade CUSTOM

Please help me with the resolution on this scenario. Looking forward for your help to resolve this problem.

Thanks 

Navya

[Akash_Varuna]

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.

[NavyaMounika]

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,

Navya

[v-echaithra]

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.

[NavyaMounika]

Thank you for your suggestion.

but this will give only give account names - only multiple or single selection

but i need to show only those accounts when i select 3 task names, accounts are falling under only those 3 task names

[NavyaMounika]

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

[Akash_Varuna]

Hi @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

[NavyaMounika]

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

[NavyaMounika]

Hi All,

Can anyone help me out in this scenario.

Thanks in Advance!

Regards,

Navya