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

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.

  • Anonymous's avatar
    Anonymous
    Not applicable
    1 year ago

    Anonymous  Yes this works , and one more thing is that the slicer order is changed ..

     

     

     

     

    • Anonymous's avatar
      Anonymous
      Not applicable
      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

        Anonymous  Cool it works well now. Thanks a lot 🙂