cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
Highlighted
rougester Frequent Visitor
Frequent Visitor

New to Power BI - Data & KPI Question

Hi,

 

The business I work for is going through system change and we have had our new data visualisation tools installed - Power BI!

 

I'm currently playing around with the package and have some questions regarding dataset.

 

...please bear with me, minimal experience and I've been thrown in at the deep end!

 

Regarding data, I have directed the desktop software at a basic sales database to get started and to practie with which includes columns for sales value, week number, year, store name.

 

My question, what is best practice for datasets? Would users tend to have multiple columns of 'sales value' for, say, each year?

 

For example, I'm trying to set up a KPI visual (I know, perhaps running before I can walk?) to show a +/- prior year variance. Do I need to create measures off the 'sales value' field which include year filters for the KPI visual to work?

 

This post might sound ridiculous but I appreciate any help offered.

 

Thanks,

M.

2 REPLIES 2
v-ljerr-msft Super Contributor
Super Contributor

Re: New to Power BI - Data & KPI Question

Hi @rougester,


For example, I'm trying to set up a KPI visual (I know, perhaps running before I can walk?) to show a +/- prior year variance. Do I need to create measures off the 'sales value' field which include year filters for the KPI visual to work?


If I understand you correctly, you may need to create a measure to calculate the prior year sales value, so that you can use the measure as target on a KPI visual to show the variance on your report. Smiley Happy

 

r2.PNG

 

Regards

rougester Frequent Visitor
Frequent Visitor

Re: New to Power BI - Data & KPI Question

Thank you @v-ljerr-msft

 

I was a little unsure if my dataset was 'general' practice or not. It looks as though it is and that measures need to be created for variances.

 

I'm getting issues with my KPI still, but I'll caryy on muddling through - practice is the key, right?!

 

thanks again for you reply Smiley Happy

Helpful resources

Announcements
Can You Solve These Challenge

Challenge: Can You Solve These?

Find out how to participate in the first Power BI 'Can You Solve These?' challenge.

Community News & Announcements

Community News & Announcements

Get your latest community news and announcements.

Virtual Launch Event

Microsoft Business Applications October Virtual Launch Event

Join us for an in-depth look at the new innovations across Dynamics 365 and the Microsoft Power Platform.

Community Kudopalooza

Win Power BI Swag with Community Kudopalooza!

Each week, complete activities and be qualified in the drawing for cool Power BI Swag.

Users Online
Currently online: 59 members 1,295 guests
Please welcome our newest community members: