cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
nautilusben
Frequent Visitor

AllSelected and Field Parameters Conditional Highlighting

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:

nautilusben_2-1669604194548.png

nautilusben_0-1669604127555.png

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_3-1669604284069.png

 

2 REPLIES 2
amitchandak
Super User
Super User

@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

Helpful resources

Announcements
Exciting changes

Power BI Community Changes

Check out the changes to the Power BI Community announced at Build.

May 2023 update

Power BI May 2023 Update

Find out more about the May 2023 update.

Kudo Data Story carousel

Data Stories Gallery

Visit our Data Stories Gallery and give kudos to your favorite Data Stories.

Top Solution Authors