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 dateJoin 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 have a decimal column in my table which can have values in the range 0-200. But When ploting in a line graph I want the maximun value to be 100. For example let's say there is a value in that column which is 150, I want it to be 100 in the graph visual. All the values above 100 should be displayed as 100. This is not same as setting a filter and excluding all the values above 100. I need the values chopped to 100. Any idea how to do this?
Solved! Go to Solution.
Hi @Deepan
You could try a calculated measure like this.
Measure = VAR coreMeasure = CALCULATE(SUM('Table2'[Values])) RETURN IF( coreMeasure>100, -- THEN -- 100, -- ELSE -- coreMeasure )
You can apply the same approach on a Calculated Column if you prefer
Just replace the code for the core measure with your own code.
Hi @Deepan
You could try a calculated measure like this.
Measure = VAR coreMeasure = CALCULATE(SUM('Table2'[Values])) RETURN IF( coreMeasure>100, -- THEN -- 100, -- ELSE -- coreMeasure )
You can apply the same approach on a Calculated Column if you prefer
Just replace the code for the core measure with your own code.
Check out the July 2025 Power BI update to learn about new features.
This is your chance to engage directly with the engineering team behind Fabric and Power BI. Share your experiences and shape the future.
User | Count |
---|---|
62 | |
62 | |
54 | |
38 | |
25 |
User | Count |
---|---|
84 | |
60 | |
45 | |
41 | |
39 |