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
Chandramouli_BI
Helper III
Helper III

Count of date in a numeric range slicer

I have created a scatter plot like this below based on the PowerBI percentile lines(25th,50th,75th,100th) for both X & Y axis in Analytics pane Option in powerBI

Chandramouli_BI_0-1697448488364.png

 

I have a date column. I created a card visual & enabled count of distinct count of date. It shows value 30 (since I enabled april month in slicer). In the slicer settings I enabled between (What I want is it should give me a range from 1 to 30) . But it is showing date range,which I dont want. I want a range between 1 to 30 & based on this value & average of service average epk I can check each grid wise data.

Also after creating the range slicer for distinct count of date, Lets say the range is from 1 to 30, if selected from 1 to 20 then in the scatter plot the values below this should come. Someone please get me through this

1 REPLY 1
Chandramouli_BI
Helper III
Helper III

I tried by separating the day from date column & then I kept day in slicer but when I select a range of 1 to 20 then in the y -axis vlaue is also showing 20 but the values count below 20 is showing wrong. Someone please get me through this

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.