Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

Enhance your career with this limited time 50% discount on Fabric and Power BI exams. Ends August 31st. Request your voucher.

Reply
VikasKarnekanti
Regular Visitor

Shape Map Ranges

Hello Team,

I am currently working with Power BI Shape Maps, where I have implemented a time slicer. I am using three columns for maps: Location, Dates Column, and Legend.

I have created a measure to calculate Achievements based on the Dates.

Now, I want to create another measure using the above measure to generate ranges for achievements using the Percentile function. However, the Percentile function does not seem to accept measures directly.

I attempted to address this by creating a summarized table and generating a column for the achievements. But, when the time slicer changes (i.e., transitioning from the start date to the end date), the data changes accordingly. Unfortunately, the ranges do not dynamically adjust for the modified data.

I am seeking guidance on creating a measure for ranges using the achievement measure. For example, the desired output ranges are: 1-30, 31-45, 46-75, 76-99.

 

 

Thank you,
Vikas

 

1 REPLY 1
Anonymous
Not applicable

 Hi @VikasKarnekanti 

 

 

Can you provide your pbix file and the results you expect? So that I can help you better. Please remove any sensitive data in advance.

 

 

 

 

Best Regards,

Jayleny

 

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

Helpful resources

Announcements
July 2025 community update carousel

Fabric Community Update - July 2025

Find out what's new and trending in the Fabric community.

July PBI25 Carousel

Power BI Monthly Update - July 2025

Check out the July 2025 Power BI update to learn about new features.