Find everything you need to get certified on Fabric—skills challenges, live sessions, exam prep, role guidance, and more.
Get startedGrow your Fabric skills and prepare for the DP-600 certification exam by completing the latest Microsoft Fabric challenge.
Hi Community..!!
Please help me out to achieve this.
I wants to see the month wise sales in a line chart. The functionality must be such that, data up to specific month selected on slicer should be represented by black line and that after specific month, by red line.
Please see the below image for your reference.
Waiting for quick solution.
Thanks in advance..!!
Solved! Go to Solution.
Hi @ppatil ,
One way I have done this is to create two measures and place them on the line chart. One for before the selected month, and the other for after the selected month. That way you can color them seperately.
Measure = sum('Table'[Value])
Hope this helps. you can even do min()/max() instead of selectedvalue() too for ranges.
Respectfully,
Zoe Douglas (DataZoe)
Follow me on LinkedIn at https://www.linkedin.com/in/zoedouglas-data
See my reports and blog at https://www.datazoepowerbi.com/
Hi @ppatil ,
One way I have done this is to create two measures and place them on the line chart. One for before the selected month, and the other for after the selected month. That way you can color them seperately.
Measure = sum('Table'[Value])
Hope this helps. you can even do min()/max() instead of selectedvalue() too for ranges.
Respectfully,
Zoe Douglas (DataZoe)
Follow me on LinkedIn at https://www.linkedin.com/in/zoedouglas-data
See my reports and blog at https://www.datazoepowerbi.com/
Join the community in Stockholm for expert Microsoft Fabric learning including a very exciting keynote from Arun Ulag, Corporate Vice President, Azure Data.
Check out the June 2024 Power BI update to learn about new features.
User | Count |
---|---|
100 | |
92 | |
89 | |
70 | |
70 |
User | Count |
---|---|
228 | |
128 | |
117 | |
83 | |
82 |