Thank you for your contributions in the community and have learnt a lot from your responses and the information you provide
I was looking at this post and was trying to solve and I used your workbook
Without changing the range, I modified "Rotulo" field as the following.
Please correct me if this is not right
1 of 1 people found this helpful
Hi Madhuri and Marco
Thank you for the input, Madhuri. Your solution looks correct from the text number stand point, but the problem exists in different place.
I took closer look and I think date range selection/ data structure is tricky.
Monthly data already includes last month end.
So, when we pick 4/1 as start and 5/1 as end, the graph always has two data point for all columns.
You can see it when you change the color transparent.
Bar height and text cannot matches because of data nature.
I'm not sure what do you expect to show when you pick multiple months, but I tried to speculate..
If you want to show ie) 3/1 ~5~1 as range, two potential views.
Thanks for you help, but I need compare one or more dates. In your chart, is considered only one.
Hi Madhuri, thanks you for input. For the range 04/01 and 05/01, the first collumn should be 1436,00 and the final, it´s total, should be 1.341,00.
Thanks for all, Madhuri and Shin.
Shin solved my problem, thanks a lot.
You are welcome.