Forum Discussion
Dinamic bar chart dependent on slicer button
That makes more sense. I don't have time for a detailed reply just now but I think you could adapt one of these to what you want.
https://www.youtube.com/watch?v=duMSovyosXE&t=565s&ab_channel=BIElite
https://www.youtube.com/watch?v=MooZofz5GOI&ab_channel=EnterpriseDNA
Super UserBI Elite has some good demos on this topic.
https://www.youtube.com/c/BIElite/search?query=dynamic%20chart%20with%20slicer
I'm not sure I fully understand your scenario, may need some screen shots and data to be able to better help.
Thanks for your reply!,
Actually, I'm trying to replicate this report on BI
So everytime a different date is selected the bar chart changes showing the last 7 days since the date selected, meanwhile the table has the info of the day.
Here is part of the data I do have
The left bar chart has the total amount of "cps" per day,
I hope I explained myself a bit better, Thank you.
- Ashish_Mathur
Hi,
See if my solution here helps - Flex a Pivot Table to show data for x months ended a certain user defined month.
- KNP
That makes more sense. I don't have time for a detailed reply just now but I think you could adapt one of these to what you want.
https://www.youtube.com/watch?v=duMSovyosXE&t=565s&ab_channel=BIElite
https://www.youtube.com/watch?v=MooZofz5GOI&ab_channel=EnterpriseDNA
Thank you! I will give it a try.
