Forum Discussion

Excel-lent-User's avatar
Excel-lent-User
Regular Visitor
2 years ago
Solved

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.
Need Help
  • Anonymous's avatar
    Anonymous
    2 years ago

    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.

NaveenGandhi's avatar
NaveenGandhi
Memorable Member
2 years ago

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

  • Anonymous's avatar
    Anonymous
    Not applicable
    2 years ago

    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.