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.
Hi,
Im hoping to get some assistance with a Measure im using to highlight the largest and smallest columns in a visual.
I am running into the follwing issue:
I imagine this is largely due to the use of field Parameters to group my Dates,weeks, quarters and years data. Is there a simple solution I can apply to my measure?
Ideally returning the following:
@nautilusben , Your minx and maxx need to change like
calculate( minx(values(Date[Date]), [Measure]), allselected(Date[Date]))
and
calculate( minx(values(Date[Date]), [Measure]), allselected(Date[Date]))
If this does not help
Can you share sample data and sample output in table format? Or a sample pbix after removing sensitive data.
Hi @amitchandak,
Thanks for your reply,
unfortuantely I am still having difficulty with making this work. I wasnt able to attached the document in this forum space, but have provided a dropbox link below:
https://www.dropbox.com/s/0mqrebpjwqpy1gm/Incoming%20Error.pbix?dl=0
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 |
---|---|
110 | |
94 | |
81 | |
66 | |
58 |
User | Count |
---|---|
150 | |
119 | |
104 | |
87 | |
67 |