Dynamic axis Report Builder Power BI
Hi everybody! Can you help me out with dynamic axis in Power BI report builder? For a report I am building in Power BI report builder, I am creating bar charts and column charts. As you know, charts are dynamic, which causes the issue that sometimes there is not enough room to place the datalabels outside. To solve this matter, I want to create a dynamic axis. The below graph is an example of what I want to achieve. For this graph, everything worked fine. I was able to get the result by the following expression for the MAX value: for my y-axis: =Max(Count(Fields!Matchkey.Value))*1.1 I now want to achieve the same result for a bar chart: But, if I use the same formula to determine the max value for my x-axis, I get the following result: I have two parameters in my report. After selecting the parameter values and running the report, the total Matchkeys in this particular selection is 381. However, it should pick in this case the 117 (= the max value for this graph) and multiply this with 1.1 to create a margin so that the labels fit next to the bar, but it is picking up the total Matchkeys, instead of the Max matchkey count for this selection. Does anyone know how to solve this matter? Formula's I have tried already, are: =MAX(Fields!Matchkey.Value)*1.1 =MAX(Fields!Matchkey.Value)*2 =Count(Fields!Matchkey.Value) =MAX(Count(Fields!Matchkey.Value)) =MAX(Count(Fields!Matchkey.Value)) *1.1 ChatGPT is not helpful unfortunately. As a suggestion it's giving me to create a calculated field that calculates the max value, and then use that in my expression to determine the max value. I could not do that as it gives me the error that you cannot use an aggregate function in a calculated field (COUNT and MAX). It appears the report processes the axes for bar charts differently then for column charts. Does anyone know what I should do? Help is very much appreciated!
