Power BI is turning 10, and we’re marking the occasion with a special community challenge. Use your creativity to tell a story, uncover trends, or highlight something unexpected.
Get startedJoin 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.
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:
How can I fix that?
@Anonymous I just tried this and it worked fine. What did you use for an increment? Did you use new Parameter, Numeric Range?
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).
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!
@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.
This is your chance to engage directly with the engineering team behind Fabric and Power BI. Share your experiences and shape the future.
Check out the June 2025 Power BI update to learn about new features.
User | Count |
---|---|
79 | |
78 | |
57 | |
37 | |
34 |
User | Count |
---|---|
99 | |
56 | |
56 | |
46 | |
40 |