Forum Discussion
Conditional with dynamic values
Hello friends, how are you? With your help I was able to implement the status of one piece of equipment per year in a pie chart.
Now I wanted to implement another pie chart, where I can add up the equipment, regardless of the status. With the 2 graphs I can see the associated information.
Ex: 2024
Ex: 2025
I inserted a spreadsheet to demonstrate what I need in the pie chart. The number of equipment will not change, but I need this relationship between the graphs to view the information
Ex: 2024
When I switch to 2025:
Can any friend help me?
Regards
Hi msam86
Try the following Measure:
Measure 2 = VAR select_client = SELECTEDVALUE(Dados[Client]) RETURN COUNTX( FILTER(ALL('Dados'),[Client]=select_client),[Client])Best Regards,
Jayleny
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
6 Replies
Hi msam86
All you need to do is put the fields from your existing table into the pie chart.
Best Regards,
Jayleny
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
Hi Anonymous , I understand what you said, but I need another pie chart with customer information. For example, I need to see A = 33, B = 9, C=4....
RegardsHi msam86
Drag the column "equipment" into Legend.
Best Regards,
Jayleny
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
Hello my friends,
Can anyone help?
RegardsHi msam86
Try the following Measure:
Measure 2 = VAR select_client = SELECTEDVALUE(Dados[Client]) RETURN COUNTX( FILTER(ALL('Dados'),[Client]=select_client),[Client])Best Regards,
Jayleny
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
