Forum Discussion

nautilusben's avatar
nautilusben
Frequent Visitor
3 years ago

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:

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:

 

 

Need Help

2 Replies

  • amitchandak's avatar
    amitchandak
    Super User
    3 years ago

    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.