Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.
Hi All,
Is it possible to have dynamic start and end value in line and stacked column chart?
I have two Y-Axis in chart and I set up start and end value to not have so flat bars but after filtering data amounts changes and bars dissapear.
Maybe there is possibility to make a macro for it or what kind of solution can you propose?
Right now I have two Y-Axis and for bars the start value = 9k and end value = 12k.
Chart before and after filtering.
Flat bars chart
Of course it is only example but I'm generally interested in such solution.
Solved! Go to Solution.
@Anonymous I put this together, it may or may not be what you are looking for. Basically, create 2 measures:
Below = MINX(ALL('Table'),[Column])
Above = SUM('Table'[Column]) - [Below]
Use a Stacked column and line chart. Put the two measures in your Column values. Set the Below color to the same as your background (white for example). I have attached a PBIX for your review (below sig). It does have the effect of making your column heights more distinctive. But, it also floats them out into space.
Hi @Anonymous ,
Will the methods above meet your requirements?
Best Regards,
Icey
@Anonymous I put this together, it may or may not be what you are looking for. Basically, create 2 measures:
Below = MINX(ALL('Table'),[Column])
Above = SUM('Table'[Column]) - [Below]
Use a Stacked column and line chart. Put the two measures in your Column values. Set the Below color to the same as your background (white for example). I have attached a PBIX for your review (below sig). It does have the effect of making your column heights more distinctive. But, it also floats them out into space.
Hi @Anonymous ,
There is no possibility to make the start and end y-axis dinamic one option is to create a measure with a variable value that you place in your chart and blank out that value can be then use to make your visualization always stay within those parameters but be aware that this value needs to be higher than you maximum value you cannot make it lower othewise you will get the same result.
Regards
Miguel Félix
Proud to be a Super User!
Check out my blog: Power BI em PortuguêsCovering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City
Check out the April 2024 Power BI update to learn about new features.
User | Count |
---|---|
109 | |
98 | |
77 | |
66 | |
54 |
User | Count |
---|---|
144 | |
104 | |
100 | |
86 | |
64 |