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 |
---|---|
123 | |
63 | |
56 | |
47 | |
41 |
User | Count |
---|---|
113 | |
65 | |
59 | |
58 | |
45 |