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

Get certified in Microsoft Fabric—for free! For a limited time, the Microsoft Fabric Community team will be offering free DP-600 exam vouchers. Prepare now

Reply
RaphaelDalmeida
Frequent Visitor

PowerBI Scorecard Calculation Groups and Hierarchy Filter

Hi,

 

I am developing a Scorecard in the PowerBI Portal, using the Goals/Scorecard feature.

 

Trying to find a way to display Month to Date and Year to Date Goals in a simple and concise way.

 

It does not seem possible to have an additional column created for values (to display as an additional linked metric), therefore whenever you connect a Metric to a dataset, it will only display one column for value where you connected.

 

Alternatively i was attempting to use the new Hierarchies features to possibly created a "filter" that allows me to swap between MTD and YTD by using Calculation Groups in my source models. The issue with this approach is that, it seems that whenever i filter the data to a different calculation group the trend in the Scorecard is lost.

 

Measure on Scorecard

RaphaelDalmeida_0-1718845291974.png

 

Using calculation column in hierarchy filtering calculation item = Month to date (trend disappears from in progress)

RaphaelDalmeida_1-1718845310999.png

 

Using calculation column in hierarchy filtering calculation item = Year to date (trend disappears from in progress)

RaphaelDalmeida_2-1718845326448.png

 

Using calculation column in hierarchy - cleared filters (trend shows up)

RaphaelDalmeida_3-1718845342081.png

 

 

Selected measure used in the chart (and brought into the scorecard):

Average Duration of Unplanned Interruptions (Weighted) = SUM([Total Water Off Minutes Weighted by Customers])/SUM([Unplanned_Water_Interruptions_Affected_Customer_Count])

 

Calculation items:

Month to date = TOTALMTD(SELECTEDMEASURE(),'Date'[Calendar Date])
Year to date = TOTALYTD(SELECTEDMEASURE(),'Date'[Calendar Date], "30/6")
 
 
Any help is welcome, thanks.
1 ACCEPTED SOLUTION
Anonymous
Not applicable

Hi @RaphaelDalmeida ,

Ensure that hierarchies are mapped correctly to the semantic model and that data is not inadvertently filtered or hidden. You can refer to the following documentation to understand the hierarchy in the scorecard:
Get started with hierarchies in Power BI metrics - Power BI | Microsoft Learn

 

Best Regards,

Ada Wang

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

 

View solution in original post

2 REPLIES 2
Anonymous
Not applicable

Hi @RaphaelDalmeida ,

Ensure that hierarchies are mapped correctly to the semantic model and that data is not inadvertently filtered or hidden. You can refer to the following documentation to understand the hierarchy in the scorecard:
Get started with hierarchies in Power BI metrics - Power BI | Microsoft Learn

 

Best Regards,

Ada Wang

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

 

I've changed a few things in my model, created a parameter table and have the MTD/YTD filter done at my calculation groups it seems to be working perfectly now.

 

On another note, do you know if there's anyway to pre-apply a hierarchy in the scorecard ? so it saves the selection for other users.

 

Thanks for your help.

Helpful resources

Announcements
OCT PBI Update Carousel

Power BI Monthly Update - October 2024

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

September Hackathon Carousel

Microsoft Fabric & AI Learning Hackathon

Learn from experts, get hands-on experience, and win awesome prizes.

October NL Carousel

Fabric Community Update - October 2024

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

Top Solution Authors
Top Kudoed Authors