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

Earn the coveted Fabric Analytics Engineer certification. 100% off your exam for a limited time only!

Reply
Gregwoolley2387
Regular Visitor

Dashboard KPIs, slicers, and financial data

Hi all,

 

I've built the below dashboard, but I'm finding a few seprate issues which I haven't been able to solve through my trial & error and searches so far.  

https://app.powerbi.com/view?r=eyJrIjoiNzlkOTQ0ZmEtNjY3ZS00YTFiLWI1NzQtNTBjYTE2YTllZjI1IiwidCI6IjdkN...

 

1. The top KPIs:

(a) the 'target' number will only let me show a count of the data I'm, selcting rather than a sum. (I have checked that the source data is a 'number' rather than text)

(b) the slicer (by year) seems to work on these figures, but when a year isn't selected, I thoguht it would the sum of the relevant data, but this isn't the case. I'm not sure why? Or perhaps I've misunderstood how the slicer works.

 

2. The bar charts:

(a) Is it possible to adjust the size of the plot area specifically to allow more space for the legend? I need to present all legend entries. Or are there any other alternatives people could suggest? 

(b) I don't understand why the year slicer isn't effecting the bar charts also?

 

3. The bottom charts:

(a) I'm struggling to present financial data in Power BI. I think the main reason is that in Excel you woul dusually format data in matrix style table. However, I'm unsure how to structure flat data so that it can present the usual financial data points. E.g. income versus budget, expenditure verus budget, for different years.

 

Apologies, I appreciate these cover a variety of areas. If you're able to help on any single items or multiple items I would be very appreciative!

 

(also I can share the Excel if that helps - but I'll need an email address I think, otherwise unsure how to share)

Best wishes, Greg

3 REPLIES 3
v-juanli-msft
Community Support
Community Support

Hi

1.

1.1 If it is not caused by column formatted as a text (not number), An alternate solution would be to define a measure that does the summarization for you and use that in your KPI (could be something as simple as Measure = SUM(Table1[Target]).

1.2 To ensure year slicer to work, you need to create measures to reflect the changes by selecting in the slicer. What do you want to show with the slicer?

 

2.

2.1 you may change the legend position to left to see more legends.

2.1 To let your bar charts change with the slicer, the tables which contain the fields in visuals should have relationships with the date column added to slicer.

 

If neither of those work, maybe share a excel file or pbix, you can share your files over a OneDrive link, upload your file to OneDrive, then right-click on the file to copy its link, in community insert this link.

additionally, you'd better post one question in one post so that more people will see and help you.

 

 

 

Best regards

Maggie

@v-juanli-msft

 

Thank you for the reply Maggie. And noted on the one question per post recommendation!

 

I've done some reconfiguring of my Excel since I posted. This is my latest version of my Excel.

 

https://can554-my.sharepoint.com/:x:/r/personal/canadmin_can-online_org_uk/Documents/Social%20Invest...

 

I think my main issue is getting the correct relationships between my three tables (each in seprate sheets above). I would like to apply a slicer by 'year' and 'scheme name', but when this is done currently it only shows a 'cut of data' according to the specific data table I pull 'year' / 'scheme name' from, e.g. KPIs_Data, and therefore any charts using 'AreaofNeed_Data'.

 

How do I best go about creating realtionships between these so a selection of a year or scheme anem affects all graphs (irrelevant of which table they refer to)? 

 

https://app.powerbi.com/groups/me/reports/ccf47cd1-c0c7-4204-be44-fc56cf217b6c?ctid=7d7938e1-7e87-4d...

 

 

Thank you.

Hi

When i click on links, it doesn'r work for me.

13.png

Helpful resources

Announcements
April AMA free

Microsoft Fabric AMA Livestream

Join us Tuesday, April 09, 9:00 – 10:00 AM PST for a live, expert-led Q&A session on all things Microsoft Fabric!

March Fabric Community Update

Fabric Community Update - March 2024

Find out what's new and trending in the Fabric Community.