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

Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.

Reply
DebbieE
Community Champion
Community Champion

New Hierarchy Variance Table I don't understand baseline target and Variance

Spoiler
Just testing the new visuals with some public crime data and I dont really understand the outcome of this visual
4Robbery.JPG

5RobberyStats.JPG

The above visual in the spoiler is using data (Above). there are 9 rows of data in this data set. Baseline says 3. Target says 4 but that only comes to 7? I just need to figure of how Baseline and Target relate the this data because to me it doesnt. 

I thought baseline would maybe be the first month and target may be the last but that doesnt make any sense either.

It seems to be that baseline is 2018 and Target is Q1 of 2019 but I dont really understand why that would be Target?

 

the metric is just a 1 against each row for # Crimes

Also why is variance down when its gone from 3 to 4?

Until I can understand what the values relate to I wouldnt like to add this into a power BI report

2 REPLIES 2
dax
Community Support
Community Support

Hi DebbieE,

I am not clear about your requirement, so If possible, could you please inform me more detailed information(such as your sample data and expected output) and explain me in details? Then I will help you more correctly.

Best Regards,
Zoe Zhi

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

 

DebbieE
Community Champion
Community Champion

Ive given you the sample data above?

 

Its not a requirement its a question. 

 

To me the metrics created in the new visual dont match the data. That is what Im asking for. How the Baseline, target and variance are calculated

Helpful resources

Announcements
Microsoft Fabric Learn Together

Microsoft Fabric Learn Together

Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City

PBI_APRIL_CAROUSEL1

Power BI Monthly Update - April 2024

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

April Fabric Community Update

Fabric Community Update - April 2024

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