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

To celebrate FabCon Vienna, we are offering 50% off select exams. Ends October 3rd. Request your discount now.

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
September Power BI Update Carousel

Power BI Monthly Update - September 2025

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

August 2025 community update carousel

Fabric Community Update - August 2025

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

Top Solution Authors
Top Kudoed Authors