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.
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
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.
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
Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City
Check out the April 2024 Power BI update to learn about new features.
User | Count |
---|---|
108 | |
105 | |
88 | |
74 | |
66 |
User | Count |
---|---|
126 | |
111 | |
100 | |
83 | |
71 |