Forum Discussion
Quarter data display in bar chart
hi ,
I want to display cumulative quarter wise data for the selected quarter in the slicer along with the previous quarter. for an instanace, if i select Q2, then the total sales value for the Q1 & Q2 has to be displayes in the bar chart. Here I used calendar table for slicer.
this is the dax, i used,
11 Replies
- Ahmedx
Super User
Based on your description, I created data to reproduce your scenario. The pbix file is attached in the end.
i am looking for similar output. let me try and came back. thanks a ton
Hello ahmed,
can i know how the key is created and a brief explanation about it. please.
- Ahmedx
This solution doesnt work for me . i am getting bar only for the selected quarter.
- Ahmedx
for it to work for you, you must create an unrelated table like I have in the "Slicer" file
and use it for slicingIf i use a disconnected table then it does but my other charts get affected. here is my file https://drive.google.com/file/d/1ri8pLxdwQ5dLQFgUUDBTDYW4MsKWcUFP/view?usp=drive_link
- Ahmedx
with an active connection it will not work
Hi shalini13 ,
Could you tell me if your problem has been solved? If it is, kindly Accept it as the solution. More people will benefit from it. Or if you are still confused about it, please feel free to let me know.
Best Regards,
Neeko Tang
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
