Forum Discussion
Detail Chart to Visualizations
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.
Thanks for the reply from NaveenGandhi , please allow me to provide another insight:
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.
4 Replies
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,
NGNaveenGandhi I posted a reply with more detail above
Thanks for the reply from NaveenGandhi , please allow me to provide another insight:
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.
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
