Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
1 year ago
Solved

Table is not interacted properly when select any pie chart slices

Hi Experts,

 

Table is not highlighting properly when i selected 40-50% range in pie chart.

All data from the same table data only.

Below the DAX used in pie chart ranges:

CM % split = IF('Test Delivery Updates'[CM %]<0.30,"<30%",IF('Test Delivery Updates'[CM %]>=0.30 && 'Test Delivery Updates'[CM %]<=0.40,"30-40%",IF('Test Delivery Updates'[CM %]>=0.40 && 'Test Delivery Updates'[CM %]<=0.50,"40-50%",IF('Test Delivery Updates'[CM %]>0.50,">50%"))))
 
Please help to sort this ..
 
Thanks
DK

 

data protection
General Comment
Interesting Links
Need Help
Show and Tell
Tips and Tricks
Tutorial Requests
  • Anonymous's avatar
    Anonymous
    1 year ago

    Hi Anonymous ,

    Creates a measure to be used for sorting.

    Sort = SWITCH(
MAX('Test Delivery Updates'[CM % split]),
"<30%",1,
"30-40%",2,
"40-50%",3,
">50%",4
)


    Then add this measure to the tooltip field of the pie chart.
    The legend of the pie chart is reordered by Sort By measure.

     

    Best Regards,
    Dengliang Li

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

10 Replies

  • Anonymous's avatar
    Anonymous
    Not applicable
    1 year ago

    Hi Anonymous ,

    I did not reproduce your problem in my testing.

    Below is the test data table.

     

    After selecting a slice of the pie chart, the table visual generated a corresponding interaction.


    Please check if the pie chart has no impact on the table visual due to editing interactions.


    Please see the attached pbix for reference.

    Best Regards,
    Dengliang Li

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

    • Anonymous's avatar
      Anonymous
      Not applicable
      1 year ago

      Anonymous  AnkitKukreja  Thanks for your responses 🙂

      Interaction is good only so that the result is coming but instead of filtering the exact rows it showcasing all the rows and highlighting only the rows based on the pie chart selections.

       

      Also CM% in the table is not a direct value from the table , that is also a measure :

      CM % = CALCULATE(DIVIDE([Total Actual Revenue],[Total YTD Revenue],0),ALLEXCEPT('Test Delivery Updates','Test Delivery Updates'[Account Name]))

       

      • Anonymous's avatar
        Anonymous
        Not applicable
        1 year ago

        Hi Anonymous ,

        Please refers to the following steps.

        Create a calculated table derived from the 'CM % split' column.
        And use the columns in this table to create a pie chart.

        Table = SELECTCOLUMNS('Test Delivery Updates',"CM % split",'Test Delivery Updates'[CM % split])


        Create a measure is used to set the conditional format for the 'CM%' measure.

        Color = 
VAR SelectedSlice= IF(DISTINCTCOUNT('Table'[CM % split])=1,MAX('Table'[CM % split]))
VAR _res=
SWITCH( TRUE(),
        [CM %]<0.3,"<30%",
        [CM %]<=0.4,"30-40%",
        [CM %]<=0.5,"40-50%",
        [CM %]>0.5, ">50%")
RETURN
IF(_res=SelectedSlice,
SWITCH(_res,
    "<30%","Green",
    "30-40%","Red",
    "40-50%","Yellow",
    ">50%","Brown")
)


        The final result is as follows.

         

        Please see the attached pbix for reference.

        Best Regards,
        Dengliang Li

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


  • AnkitKukreja's avatar
    AnkitKukreja
    Icon for Super User rankSuper User
    1 year ago

    Hi! Anonymous 

     

    Please check edit interactions property in case that is changed.