Forum Discussion

msam86's avatar
msam86
Icon for Helper I rankHelper I
2 years ago

Consolidade values in a pie chart

Hello friends, how are you? I need help with the following scenario: I have several cars, where there is a year related to each car. Through the selected year, I had a status according to the yea...
Need Help
Anonymous's avatar
Anonymous
Not applicable
2 years ago

Hi msam86 ,

 

If you want to check each car and all three statuses associated with it, we can first create a new measure as shown below:

 

ConsolidatedStatus = 
VAR NA_Count = countx(
    filter(('Data'),[StatusPerYear]="NA"),[StatusPerYear])
VAR OK_Count = countx(
    filter(('Data'),[StatusPerYear]="Ok"),[StatusPerYear])
VAR Recall_Count = countx(
    filter(('Data'),[StatusPerYear]="Recall"),[StatusPerYear])
RETURN
"NA: " & NA_Count & ", OK: " & OK_Count & ", Recall: " & Recall_Count

 

Then modify the chart like this:

In this way, when we hover on the part of the visual, we can view different types of cars and the number of associated states.

Best regards,

Joyce

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

 

msam86's avatar
msam86
Icon for Helper I rankHelper I
2 years ago

Hi Anonymous,

 

Thanks for your response.

I think you solved part of my problem. Now I can see the consolidated cars, but I need to count this status (Recall, Ok and NA), and return this number by type of car.

It's possible?

Regards




  • Anonymous's avatar
    Anonymous
    Not applicable
    2 years ago

    Hi msam86 ,
    Yes, you could check the count of status by type of car in Tooltips:

    • msam86's avatar
      msam86
      Icon for Helper I rankHelper I
      2 years ago

      Hi Anonymous 

       

      I saw it in the tooltips. I just want to add ConsolidatedStatus of car. I would like to see for Volvo number 3 (NA 2 + OK 0 + Recall 1).
      This way it will be reflected for other cars and the pie chart will be cleaner.

      Thanks a lot for your help.