Play Axis showing unnecessary data

[Anonymous]

Hello,

I'm putting together a graph of grouped columns and lines, I have to use Play Axis, however when using it I realized that it divided my column of the graph between the original value and a highlighted one. I understood what he is doing, as I have several lines of work, and each line has a working time, he is adding all the values ​​"UPP REAL" and putting the maximum value of the column as this sum, but I don't I would like this sum to be made, just that he put the value of the UPP REAL of each line of work individually.

Below is an example of how he is behaving:

And here was how he should behave:

Here is my PBIX to help with visualization (File.pbix )

[v-shex-msft]

Hi @Anonymous,

AFAIK, power bi charts will auto aggregate records based on the current date category.
It is impossible to direct cancel these aggregate operations except you add more data categories to your visual axis and drill them to the bottom level.

In addition, you can change to table visual to use 'not summarize' fields to display all records.

Regards,

Xiaoxin Sheng

[Anonymous]

@v-shex-msft Can you explain a little more, please?

[MFelix]

Hi @Anonymous ,

Have you tried changin the interactions between the play axis and the bar chart for filter instead of highligth?

That will change the bar chart to full columns for each axis change, instead of just part of the bar.

[Anonymous]

@MFelix Can you explain a little more, please?