Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

Find everything you need to get certified on Fabric—skills challenges, live sessions, exam prep, role guidance, and more. Get started

Reply
Anonymous
Not applicable

Tile for Actual, Plan, and Forecast Sales KPI's

Good Morning!

 

I will appreciate suggestions on which tile to use (card, multi row card, guage, KPI, ...) to compare Actual, Plan, and Forecast sales. 

 

Trying to show all 3 in one tile if possible.  

 

From what I can tell (using a Guage), you can compare Actual with Plan or Forecast, but not all three.

 

Also trying to make is visually appealing.

 

Many Thanks!

 

Pavan

 

3 REPLIES 3
Anonymous
Not applicable

you can get custom visual from power bi custom visuals.

 

Anonymous
Not applicable

Thanks Miguel.

I like the Guage and KPI tiles - but need to be able to show numbers for Plan, Actual, and Forecast . 

eg. Plan is 1000, Actual is 900, Forecast is 800 - trying to show it as one visual.  

(i think Guage and KPI can only work with 2 measures - value and target value).

Trying to keep the number of tiles less and have it visually appealing.  

My last resort is to use a bar chart.

Thanks again!

Pavan

MFelix
Super User
Super User

Hi @Anonymous ,

 

This depends on the type of comparision you want to do, if it's only a simply value side by side you can use the 3 cards, a multi row card, or even a table or matrix, if you want something that shows the variation you may do it with different visualizations but again depend on what you want to show.

 

Can you give a better explanation of what you want to achieve.


Regards

Miguel Félix


Did I answer your question? Mark my post as a solution!

Proud to be a Super User!

Check out my blog: Power BI em Português



Helpful resources

Announcements
Fabcon_Europe_Social_Bogo

Europe’s largest Microsoft Fabric Community Conference

Join the community in Stockholm for expert Microsoft Fabric learning including a very exciting keynote from Arun Ulag, Corporate Vice President, Azure Data.

Power BI Carousel June 2024

Power BI Monthly Update - June 2024

Check out the June 2024 Power BI update to learn about new features.

PBI_Carousel_NL_June

Fabric Community Update - June 2024

Get the latest Fabric updates from Build 2024, key Skills Challenge voucher deadlines, top blogs, forum posts, and product ideas.

RTI Forums Carousel3

New forum boards available in Real-Time Intelligence.

Ask questions in Eventhouse and KQL, Eventstream, and Reflex.