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
User | Count |
---|---|
106 | |
82 | |
72 | |
48 | |
48 |
User | Count |
---|---|
157 | |
89 | |
81 | |
69 | |
67 |