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...
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.

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.


    • Anonymous's avatar
      Anonymous
      Not applicable
      1 year ago

      Anonymous  Yes this also recommeneded when we have very less no. of accounts in the table to highlight color.

      But in my dashboard we have more than 150+ accounts (rows) so still we have to scroll down to see the color highlighting rows. 

      It would be a manual thing again for the stalkholders to scroll until the end to see the results.

      • Anonymous's avatar
        Anonymous
        Not applicable
        1 year ago

        Hi Anonymous ,

        In that case, then you can create a pie chart using the CM % split column in the source table Test Delivery Updates.
        Then set the conditional format of [CM %] using the following measure.

        Color2 = 
VAR SelectedSlice = CALCULATE(
    IF(DISTINCTCOUNT('Test Delivery Updates'[CM % split])=1,MAX('Test Delivery Updates'[CM % split])),
    ALLSELECTED('Test Delivery Updates'[Account Name],'Test Delivery Updates'[YTD Revenue])
    )
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")
)


        This way, when you select any slice of the pie chart, the corresponding row is highlighted in the table visual. When you deselect the slice, all rows are displayed in the table visual.


        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.