Detail Chart to Visualizations

[Excel-lent-User]

I want to be able to select a product name in a table visualization and have it filter a Product Name slicer.  NO luck so far, is this even possible? I can provide more detail if needed as well.

[Excel-lent-User]

My desired outcome is to have the team I select in the detail chart to be sent to the slicers to let the user experience run smoother, and then, from the slicers I want only the team context to be transferred to the visualization. (Final product will show the chosen team name and all previous periods) This is useful for understanding how lifetime attendance matters for specific periods while seeing it highlighted for individual ones

[NaveenGandhi]

Hi @Excel-lent-User 

You can't slice a slicer from a table, If you can explain what exactly is the requierment with sample file and sample output. It will be easy to have a look.

Regards,
NG

[Excel-lent-User]

@NaveenGandhi I posted a reply with more detail above

[Anonymous · Accepted solution]

Thanks for the reply from @NaveenGandhi , please allow me to provide another insight:

Hi,@Excel-lent-User 

Regarding the issue you raised, my solution is as follows:

1.First I have created the following table and the column names and data are the data you have given:

2. Below are the measure I've created for your needs:

Measure = 
VAR select1=MAX('Table'[Country])
RETURN IF(ISFILTERED('Table'[Country]),CALCULATE(SUM('financials'[Profit]),FILTER('financials','financials'[Country]=select1)),SUM(financials[Profit]))

Measure 2 = MAX('Table'[Country])

3.Here's my final result

Understand how visuals interact in a report - Power BI | Microsoft Learn 

Filters and highlighting in Power BI reports - Power BI | Microsoft Learn

As you can see from the above, cross-highlight has an effect on the visualization, but not in the dax function or in the slicer. So your needs can't be fulfilled with DAX for the time being.

For your question, I suggest using the slicer control directly:

Slicers in Power BI - Power BI | Microsoft Learn
 

If you have any new findings, please let us know.

Please find the attached pbix relevant to the case.

Best Regards,

Leroy Lu

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.