Non aggregated value in charts

[tuulia]

Hi!

I need to show non aggregated values in a chart. I got some summarized data from third-party organization and I need to show datavalues (= items) as they are.

Exampledata:

product 1, 100 items

product 2, 150 items

product 3, 175 items

product 4, 198 items

These values (= items)  works fine in a table/matrix but not in chart and there's no "don't summarize" option when I use charts.

[tuulia]

@Anonymous  Thank you so much, I'll check this solution!

[Anonymous · Accepted solution]

Hi @tuulia ,

Greg is right.
What kind of visuals do you use? Here I added an index column and inserted a rectangle of the same color as the background to cover the index axis, which looks like this.

The PBIX file is attached for reference.

Best Regards,
Gao
Community Support Team

If there is any post helps, then please consider Accept it as the solution  to help the other members find it more quickly. If I misunderstand your needs or you still have problems on it, please feel free to let us know. Thanks a lot!

How to get your questions answered quickly -- How to provide sample data

[Greg_Deckler]

@tuulia Correct.

[tuulia]

🤔