Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.
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!
Solved! Go to Solution.
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
Have I solved your problem? Please click Accept as Solution so I don't keep coming back to this post, oh yeah, others may find it useful also ;). |
If you found this post helpful, please give Kudos. It gives me a sense of instant gratification and, if you give me Kudos enough times, magical unicorns will appear on your screen. If you find my signature vaguely amusing, please give Kudos. | Proud to be a 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.
Have I solved your problem? Please click Accept as Solution so I don't keep coming back to this post, oh yeah, others may find it useful also ;). |
If you found this post helpful, please give Kudos. It gives me a sense of instant gratification and, if you give me Kudos enough times, magical unicorns will appear on your screen. If you find my signature vaguely amusing, please give Kudos. | Proud to be a Super User! |
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.
Hi,
See if my solution here helps - Flex a Pivot Table to show data for x months ended a certain user defined month.
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
Have I solved your problem? Please click Accept as Solution so I don't keep coming back to this post, oh yeah, others may find it useful also ;). |
If you found this post helpful, please give Kudos. It gives me a sense of instant gratification and, if you give me Kudos enough times, magical unicorns will appear on your screen. If you find my signature vaguely amusing, please give Kudos. | Proud to be a Super User! |
Thank you! I will give it a try.
Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City
Check out the April 2024 Power BI update to learn about new features.
User | Count |
---|---|
108 | |
100 | |
78 | |
64 | |
58 |
User | Count |
---|---|
148 | |
111 | |
94 | |
84 | |
67 |