Get certified for free when you join Fabric Data Days 2026 and dive into Fabric, Power BI, SQL, AI, and other essential data skills.
Join nowData Days is here! Join us now for 60+ days of learning, challenges, and connection. Learn more
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
Don't miss out on Data Days, June 15 through August 7. Learn Fabric, Power BI, SQL, AI and more.
Check out the May 2026 Power BI update to learn about new features.
| User | Count |
|---|---|
| 23 | |
| 21 | |
| 20 | |
| 19 | |
| 13 |
| User | Count |
|---|---|
| 58 | |
| 52 | |
| 37 | |
| 31 | |
| 27 |