How to Pie chart can be interacted with table visual and stacked Colum chart without using legends

[Rockz]

Dear Champions,

I need your help here am using a piechart where this pie chart to be interacted with table and bar chart visual. I'm not using legends here and using only values as measures. how can I achieve this ? and I have tried edit interactions as well but it didn't worked.

Thanks in advance.

[Anonymous · Accepted solution]

Thanks for the reply from amitchandak  please allow me to provide another insight:

Hi, @Rockz 
 

Can you tell me if your problem is solved? If yes, please accept  amitchandak's reply as solution.
 

If not, can you explain to us what the interaction in your needs means?
 

1.If you want the data to be highlighted after selecting the visualization, in this case, as long as there is a relationship between the data, it can be correlated and displayed normally, the following are my actual results:

Here are the official documents for this:
Understand how visuals interact in a report - Power BI | Microsoft Learn
 

2.If you want to visualize the impact on the display of the data itself, we recommend using a slicer visualization:

Of course, filters are also a good choice:

Here is the relevant documentation:

 Slicers in Power BI - Power BI | Microsoft Learn
Add a filter to a report in Power BI - Power BI | Microsoft Learn
 

Can you share sample data and sample output in tabular format if I am misunderstanding? Or a sample pbix after removing sensitive data. We can better understand the problem and help you.

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.

[Rockz · Accepted solution]

Dear Thanks for your quick response,

So In the below Piechart when I click on any of the measure value for example in below pie chart Iam using close within in the time so when I click on that measure then beside visual should also filter and give the result. This is the measure Iam using in Piechart values.

Closed within the time =
VAR X = [Selected Number of Days]
VAR AllowedTime = X * 6 * 60
RETURN
CALCULATE(
COUNTROWS('XYZ_Table'),
'XYZ_Table''[status] IN {"Close", "Complete"} &&
'XYZ_Table'[Processing Time] <= AllowedTime

Hope you got my issue. and I have tried what amitchandak sugggested  by using Group calculations but it is not working.

Thank you.

[Rockz · Accepted solution]

Dear Thanks for your quick response,

So In the below Piechart when I click on any of the measure value for example in below pie chart Iam using close within in the time so when I click on that measure then beside visual should also filter and give the result. This is the measure Iam using in Piechart values.

Closed within the time =
VAR X = [Selected Number of Days]
VAR AllowedTime = X * 6 * 60
RETURN
CALCULATE(
COUNTROWS('XYZ_Table'),
'XYZ_Table''[status] IN {"Close", "Complete"} &&
'XYZ_Table'[Processing Time] <= AllowedTime

Hope you got my issue. and I have tried what amitchandak sugggested  by using Group calculations but it is not working.

Thank you.

[Anonymous · Accepted solution]

Hi, @Rockz 

My understanding of your question is that you need to click on any of the metrics that make up the pie chart in the pie chart visualization object, then apply the metric f filter to the other visualizations and output the results in the other visualizations.

At the moment, it's not possible to click on the visualization to achieve the data filtering you need.

But you can try using slicers as an alternative to the way you switch:

For example, I create data like this:

The following measure is then created in the pie chart as a filler:

Closed within the time = 
VAR X = [Selected Number of Days]
VAR AllowedTime = X * 6 * 60
RETURN
CALCULATE(
COUNTROWS('XYZ_Table'),
'XYZ_Table'[status] IN {"Close", "Complete"}&&
'XYZ_Table'[Processing Time] <= AllowedTime)

Unclosed within the time = 
VAR X = [Selected Number of Days]
VAR AllowedTime = X * 6 * 60
RETURN
CALCULATE(
COUNTROWS('XYZ_Table'),
'XYZ_Table'[status] IN {"Active"}&&
'XYZ_Table'[Processing Time] <= AllowedTime)

1.As an alternative, you can use a slicer as a toggle:

2.Then you can use the following measure to switch between filters:
 

MEASURE = 
VAR X = [Selected Number of Days]
VAR AllowedTime = X * 6 * 60
VAR a1 =
    CALCULATE (
        SUM ( 'XYZ_Table'[Processing Time] ),
        'XYZ_Table'[status]
            IN { "Close", "Complete" }
                && 'XYZ_Table'[Processing Time] <= AllowedTime
    )
VAR a2 =
    CALCULATE (
        SUM ( 'XYZ_Table'[Processing Time] ),
        'XYZ_Table'[status]
            IN { "Active" }
                && 'XYZ_Table'[Processing Time] <= AllowedTime
    )
RETURN
    IF (
        ISFILTERED ( 's'[kk] ),
        IF ( MAX ( 's'[kk] ) = "Closed within the time", a1, a2 ),
        SUM ( 'XYZ_Table'[Processing Time] )
    )

3.Here's the end result, hopefully for your needs:

If you feel that performance needs to be improved, you can also submit an idea on

https://ideas.fabric.microsoft.com/ and wait for users with the same needs as you to vote for you and help you realize the idea as soon as possible. Many features of our current products are designed and upgraded bed on customers’ feedback.  With requirements like this increase, the problem may well be released in the future.

Thanks for your understanding.
 

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.

[Anonymous · Accepted solution]

Thanks for the reply from amitchandak  please allow me to provide another insight:

Hi, @Rockz 
 

Can you tell me if your problem is solved? If yes, please accept  amitchandak's reply as solution.
 

If not, can you explain to us what the interaction in your needs means?
 

1.If you want the data to be highlighted after selecting the visualization, in this case, as long as there is a relationship between the data, it can be correlated and displayed normally, the following are my actual results:

Here are the official documents for this:
Understand how visuals interact in a report - Power BI | Microsoft Learn
 

2.If you want to visualize the impact on the display of the data itself, we recommend using a slicer visualization:

Of course, filters are also a good choice:

Here is the relevant documentation:

 Slicers in Power BI - Power BI | Microsoft Learn
Add a filter to a report in Power BI - Power BI | Microsoft Learn
 

Can you share sample data and sample output in tabular format if I am misunderstanding? Or a sample pbix after removing sensitive data. We can better understand the problem and help you.

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.

[amitchandak]

@Rockz , No it can not, if you use measures. You can create a calculation group of measures and if you use that in all visuals, you can interact for measures.

[Rockz]

Dear @amitchandak 

Can you please provide me any reference document to implmenet the griup calculations?

Thank you.