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

Enhance your career with this limited time 50% discount on Fabric and Power BI exams. Ends August 31st. Request your voucher.

Reply
Syndicate_Admin
Administrator
Administrator

Represent Specific Percentage Lines in Column Chart

Good afternoon

I need to place on thechart (Figure 1),a line that is 70%,another line that is 50% and another line 30%. Therefore, I need you to see the 3 lines within the same graph. In addition to this, I need the location of theselines (70%, 50%, and 30%) to be set according to the date range selected in the date segmenter and the scale of values used on the Y axis.

So that you can detail more how the tables with which the chart was built are designed, you can see (Figure 2 and 3). Also, in Figure 4 you will see how the calculated measure that was placed in the "Values" section was performed. In Figure 5,you can see how the calculated fields and measures were placed to build the chart.

I understand that this chart, with these 3 percentage lines, you probably have to build it from a"clustered column chart and lines". Thank you very much in advance for any suggestions you can give me about it.

A greeting

Joseph I. Del Pino B.

1.JPG

Figure 1.

2.JPG

Figure 2.

3.JPG

Figure 3.

4.JPGFigure 4.

5.JPG

Figure 5.

2 REPLIES 2
amitchandak
Super User
Super User

@Syndicate_Admin , Not sure 70 % of what. But if need of max value.

 

You can create measure like

maxx(values(Date[Month year]), [measure]) *.7

 

Same way for other %

Share with Power BI Enthusiasts: Full Power BI Video (20 Hours) YouTube
Microsoft Fabric Series 60+ Videos YouTube
Microsoft Fabric Hindi End to End YouTube

Thank you for your proposal, however, do not print a straight horizontal line reflecting 30, 50 or 70%,as shown in Figure 6.

The 70% horizontal line refers to the overall 70% of all data in the selected period in the segmenter, i.e. it follows the same logic of the mean or average, only in this case instead of 50% it would be 70%,logically self-configuring according to the date range placed by the user in the time segmenter.

So, could you suggest anything about it?

Thanks a lot.

Capturajkkjkj.JPG

Figure 6

Helpful resources

Announcements
July 2025 community update carousel

Fabric Community Update - July 2025

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

July PBI25 Carousel

Power BI Monthly Update - July 2025

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