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 team,
I need some help to create below report in Power BI.
I have Quota and Opportunity table which has been joined by 1 to many relationship.
I am trying to plot line chart as show below (attached here sample pbix file)
Any help will be much appreciated.
Solved! Go to Solution.
You need a cumulative measure for Blue and Y-Axis Constant Lines for Yellow and Green defined by the appropriate measures.
I get this when adding those:
Please see attached.
Hi @AlexisOlson ,
Please ignore my previous message, I think it will cause too much confusion if we look at the large amount of data.
Thank you again for your help.
Hi @AlexisOlson ,
Thank you very much for your response. Yes it is working fine.
Is it possible to show what opportunities makes up the amount when we click on data point on the line graph?
e.g. If we click on 1/18 - can we show 2 opportunities in the table format which makes up 300$?
as below.
Currently it just shows 1 opportunity of 1/18 of 200$
Join the community in Stockholm for expert Microsoft Fabric learning including a very exciting keynote from Arun Ulag, Corporate Vice President, Azure Data.
Ask questions in Eventhouse and KQL, Eventstream, and Reflex.
User | Count |
---|---|
86 | |
84 | |
66 | |
62 | |
59 |
User | Count |
---|---|
197 | |
116 | |
107 | |
77 | |
70 |