Power BI is turning 10! Tune in for a special live episode on July 24 with behind-the-scenes stories, product evolution highlights, and a sneak peek at what’s in store for the future.
Save the dateEnhance your career with this limited time 50% discount on Fabric and Power BI exams. Ends August 31st. Request your voucher.
I have a table that contains a column with '% Complete' - which tracks progress of a task. I want to display, in a stacked column chart, how many tasks are within a range of 0-25%, 26-50%, 51-75% , 76-100%.
I have used the below formulas but can't seem to achieve what I need.
Form Progress 0-25% = COUNTROWS(FILTER('Master List', 'Master List'[% Complete]=0-0.25))
Form Progress 26-50% = COUNTROWS(FILTER('Master List', 'Master List'[% Complete]=0.26-0.5))
Form Progress 51-75% = COUNTROWS(FILTER('Master List', 'Master List'[% Complete]=0.51-0.75))
Form Progress 76-100% = COUNTROWS(FILTER('Master List', 'Master List'[% Complete]=0.76-1))
Would appreciate some help please!
Solved! Go to Solution.
Hello @CarolynM ,
Please try the below revsied code i have modified the same using your code..
Form Progress 0-25% = COUNTROWS(FILTER('Master List', 'Master List'[% Complete] >= 0 && 'Master List'[% Complete] <= 0.25))
Form Progress 26-50% = COUNTROWS(FILTER('Master List', 'Master List'[% Complete] > 0.25 && 'Master List'[% Complete] <= 0.5))
Form Progress 51-75% = COUNTROWS(FILTER('Master List', 'Master List'[% Complete] > 0.5 && 'Master List'[% Complete] <= 0.75))
Form Progress 76-100% = COUNTROWS(FILTER('Master List', 'Master List'[% Complete] > 0.75 && 'Master List'[% Complete] <= 1))
Alos am curious to know the error you are getting on the visual when you were trying
If you find this helpful , please mark it as solution which will be helpful for others and Your Kudos/Likes 👍 are much appreciated!
Thank You
Dharmendar S
Thank you @dharmendars007 !! That worked perfectly.
The formula I was previosuly trying to use was telling me I had too few arguments.
I've only started using Power BI in the last week, so very new at it!
Hello @CarolynM ,
Please try the below revsied code i have modified the same using your code..
Form Progress 0-25% = COUNTROWS(FILTER('Master List', 'Master List'[% Complete] >= 0 && 'Master List'[% Complete] <= 0.25))
Form Progress 26-50% = COUNTROWS(FILTER('Master List', 'Master List'[% Complete] > 0.25 && 'Master List'[% Complete] <= 0.5))
Form Progress 51-75% = COUNTROWS(FILTER('Master List', 'Master List'[% Complete] > 0.5 && 'Master List'[% Complete] <= 0.75))
Form Progress 76-100% = COUNTROWS(FILTER('Master List', 'Master List'[% Complete] > 0.75 && 'Master List'[% Complete] <= 1))
Alos am curious to know the error you are getting on the visual when you were trying
If you find this helpful , please mark it as solution which will be helpful for others and Your Kudos/Likes 👍 are much appreciated!
Thank You
Dharmendar S
Check out the July 2025 Power BI update to learn about new features.
User | Count |
---|---|
25 | |
10 | |
7 | |
6 | |
6 |
User | Count |
---|---|
30 | |
11 | |
11 | |
10 | |
6 |