Forum Discussion
Waterfall chart connected to dates
Hi Christus_CN
If my understanding is correct then you want to you want waterfall chart at the date level. So if select any specific date waterfall chart should come.
Here is my solution that i have done.
Data which i have took
Once you load data in power bi follow these steps
1. this should be your landing page in power query editor
2. then select the column you want to unpivot or vice versa if you have n number of date
like this
select that option
and your data should look like this
3. Close and apply that
4. Create water fall chart and slcier for date
it should look like this
Just one point to note that you should make slicer as single select that would be best possible way to represnet multiple select would not be correct.
If it does not help, please provide more details with your desired output and pbix file without privacy information (or some sample data) .
Check for my more solution here: https://www.youtube.com/@letssolveproblem/videos
Regards
Himanshu