Forum Discussion

Syndicate_Admin's avatar
Syndicate_Admin
Icon for Administrator rankAdministrator
5 years ago

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

  • 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 %

    • Syndicate_Admin's avatar
      Syndicate_Admin
      Icon for Administrator rankAdministrator

      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