Off topic beginner question: Is it possible to create a clustered line column chart with slicer to change specific scenarios? I have to create a column chart where I represent the fact data and the prognosis data(forecast) by month. The prognosis data is actually the specific scenarios, which the user could select to present(to see the differences between the fact and prognosis data). Additionally, to present in the Line Y-axis the scenarios(BP, CF02, CF05, CF09, CF11) within the chart. So my question is: Is it possible to handle this with slicers? The fact data and prognosis data(scenarios) are from two different table. If its not understandable, please ignore haha.
Dataset and the power bi file can be downloaded here, if anyone is interested. drive.google.com/file/d/1Buyac748IGG8vxJKtppc5vfnfUEMsTcO/view?usp=sharing
Thanks for the likes guys, this encourages us a lot.
Super helpful thanks!! This really helped me in a pinch
Thanks for your kind words.
Off topic beginner question:
Is it possible to create a clustered line column chart with slicer to change specific scenarios?
I have to create a column chart where I represent the fact data and the prognosis data(forecast) by month. The prognosis data is actually the specific scenarios, which the user could select to present(to see the differences between the fact and prognosis data). Additionally, to present in the Line Y-axis the scenarios(BP, CF02, CF05, CF09, CF11) within the chart. So my question is: Is it possible to handle this with slicers?
The fact data and prognosis data(scenarios) are from two different table. If its not understandable, please ignore haha.
No problem. Yes I believe you can. You can share dummy data and a hand drawn or other sample chart, and I will show you how its done.
@@virtual_school Just created a topic on ViSIT's forum under POWER BI topic.
Great. I have looked at it, tomorrow, I will work on it and we will solve the problem.
@@virtual_school So made a little update on Forum under the topic. I couldnt paste any link here unfortunately.
No problem, that is why I provided the forums for you guys. You can share anything there. I will have a look at it.
Dataset and the power bi file can be downloaded here, if anyone is interested. drive.google.com/file/d/1Buyac748IGG8vxJKtppc5vfnfUEMsTcO/view?usp=sharing