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

Join us for an expert-led overview of the tools and concepts you'll need to become a Certified Power BI Data Analyst and pass exam PL-300. Register now.

Reply
Anonymous
Not applicable

Slicer range not found in Power BI

I added a slicer of a 0 to 2341 column range values with "decimal number" format, but the control just show zero and one values, like the image:

hijpax_0-1696788405935.png

How can I fix that?

3 REPLIES 3
Greg_Deckler
Super User
Super User

@Anonymous I just tried this and it worked fine. What did you use for an increment? Did you use new Parameter, Numeric Range?

Greg_Deckler_0-1696789569320.png

 



Follow on LinkedIn
@ me in replies or I'll lose your thread!!!
Instead of a Kudo, please vote for this idea
Become an expert!: Enterprise DNA
External Tools: MSHGQM
YouTube Channel!: Microsoft Hates Greg
Latest book!:
Power BI Cookbook Third Edition (Color)

DAX is easy, CALCULATE makes DAX hard...
Anonymous
Not applicable

Hello @Greg_Deckler ,

 

I used the slicer from the visuals panel. I noticed that the slicer filters my data by the frecuency of the values in the summarizing column. But, I need to filter the total sum by department (the granularity of my report).

 

hijpax_1-1696892428243.png

In the last image, the frecuency of 1 in the most granular level is 33391, that is the total in the matrix, but I have departments with summarizing values like 32 or 245 or 82.. I want to filter that values! 

hijpax_2-1696892702252.png

 

@Anonymous OK, I'm super confused at this point. Is the value in the matrix a measure or is it just an aggregation of a column? I'm not following what is going on here at all so let's back up and start with the basics:

 

Sorry, having trouble following, can you post sample data as text and expected output?
Not really enough information to go on, please first check if your issue is a common issue listed here: https://community.powerbi.com/t5/Community-Blog/Before-You-Post-Read-This/ba-p/1116882

Also, please see this post regarding How to Get Your Question Answered Quickly: https://community.powerbi.com/t5/Community-Blog/How-to-Get-Your-Question-Answered-Quickly/ba-p/38490

The most important parts are:
1. Sample data as text, use the table tool in the editing bar
2. Expected output from sample data
3. Explanation in words of how to get from 1. to 2.



Follow on LinkedIn
@ me in replies or I'll lose your thread!!!
Instead of a Kudo, please vote for this idea
Become an expert!: Enterprise DNA
External Tools: MSHGQM
YouTube Channel!: Microsoft Hates Greg
Latest book!:
Power BI Cookbook Third Edition (Color)

DAX is easy, CALCULATE makes DAX hard...

Helpful resources

Announcements
Join our Fabric User Panel

Join our Fabric User Panel

This is your chance to engage directly with the engineering team behind Fabric and Power BI. Share your experiences and shape the future.

June 2025 Power BI Update Carousel

Power BI Monthly Update - June 2025

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

June 2025 community update carousel

Fabric Community Update - June 2025

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