Line Graphs and Card Visuals

[geeklarokcmie]

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

[Arul]

@geeklarokcmie ,

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.

[geeklarokcmie]

I'd like to represent the below in form of visuals:

• AI User Support forecast & actual in a Card Visual 
• AI Onboard Cost forecast & actua in a Line Graph Visual
• AI Process on Target and Behind Target can be text visual with calculation behind the scene
• Year/Quarter can be a slicer selection. Based on the selection of year/quarter the data in visuals change accordingly.

I hope that helps.

[Arul · Accepted solution]

@geeklarokcmie ,

I have attached the pbix file, please check and let me know whether that is helpful or not.

[geeklarokcmie]

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?

[Arul]

@geeklarokcmie ,

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.

[geeklarokcmie]

Maybe I will use the line graphs in seperate pages instead on the same page as cards.

Thank you again.