Forum Discussion
Dinamic bar chart dependent on slicer button
Hi Guys!
I am pretty new using power BI so the task that I was requested to do might by a bit advanced to my current level, that's why I appreciate any advice.
I have a table with dates and the number of time an equipment is loaded per day so I would like to show a bar chart with the info of the last 7 days, so when I select a new date on the slicer button the chart update.
So far I've been able to get it done however the slicer is not link to the rest of the info on the report and it only update the chart but not the rest of tables,
Thanks in Advance!
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
5 Replies
- KNP
Super User
BI 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.
