Assign point value based on quartile rank

Question

I have a KPI report that I'm developing for a site and the staff have goals that are based on quartile rank (1-4). The report I'm building has a date slider at the top as well as slicers, but I don't want the quartile to recalculate based on the slicers. Is there any way to do this within PowerBI?&nbsp;Example:&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; SPH&nbsp; SPH Score (Quartile)Agent 1&nbsp; &nbsp; &nbsp; &nbsp; 3.2&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;4Agent 2&nbsp; &nbsp; &nbsp; &nbsp; 2.2&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;1Agent 3&nbsp; &nbsp; &nbsp; &nbsp; 2.5&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;2.....Agent 200&nbsp; &nbsp; 3.1&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;3

v-huizhn-msft · Accepted Answer

Hi&nbsp;ryanmahaffey,Please click Format-&gt;Edit interactions, select the "None" button highlighted in yellow background, the visual will not be affected by slicer.Best Regards,Angelia

Forum Discussion

Assign point value based on quartile rank

1 Reply

Related content

quartile ranking

Quartiles Calculated Columns

Quartiles and average per quartile

How to unalign points?

Fabric Capacity Metrics Time point