The ultimate Fabric, Power BI, SQL, and AI community-led learning event. Save €200 with code FABCOMM.
Get registeredEnhance your career with this limited time 50% discount on Fabric and Power BI exams. Ends August 31st. Request your voucher.
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.
Figure 1.
Figure 2.
Figure 3.
Figure 4.
Figure 5.
@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 %
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.
Figure 6
User | Count |
---|---|
81 | |
74 | |
42 | |
30 | |
28 |
User | Count |
---|---|
108 | |
96 | |
53 | |
48 | |
47 |