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 |
---|---|
116 | |
61 | |
57 | |
46 | |
39 |
User | Count |
---|---|
112 | |
63 | |
63 | |
56 | |
48 |