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.
Based on the below mock data:
I'm looking to produce the below visuals:
1st Visual - Year and Quarter Selection should change the visuals accordingly
2nd Visual - AI Onboard Cost - Forecast and Actuals should be shown as line graphs
3rd Visual - AI User Support - Forecast and Actuals should be shown as cards with
4th Visual - If the forecast exceeds actuals, then a text showing AI Process on target
If the forecast is below actuals, then the a text showing AI Process behind target
Quarter | Year | AI Onboard Cost Forecast | AI Onboard Cost Actuals | AI User Support Forecast | AI User Support Actuals |
1Q | 2023 | 220000 | 200000 | 18944 | 19000 |
2Q | 2023 | 210000 | 230000 | 18246 | 18995 |
3Q | 2023 | 250000 | 300000 | 18601 | 18881 |
4Q | 2023 | 350000 | 375000 | 18662 | 18779 |
1Q | 2024 | 300000 | 400000 | 18595 | 18719 |
Solved! Go to Solution.
I have attached the pbix file, please check and let me know whether that is helpful or not.
Could please explain it in more detail if possible? Provided information is inadequate to make the visuals. Please mention which visual you want for all of them. And also the expected functionality of visual 1.
I'd like to represent the below in form of visuals:
I hope that helps.
I have attached the pbix file, please check and let me know whether that is helpful or not.
This is awesome, Arul. Thank you so much.
However, when I select a specfic quarter the line chart is not displaying accurately as a line graph?
It is expected since it sums up the value for the selected quarter alone. If you select some other quarter, you would be able to see the line between them.
Maybe I will use the line graphs in seperate pages instead on the same page as cards.
Thank you again.
User | Count |
---|---|
84 | |
80 | |
72 | |
71 | |
55 |
User | Count |
---|---|
108 | |
106 | |
93 | |
84 | |
66 |