Forum Discussion
Setting Dynamic Value for Max Value on Data Bar for Matrix Conditional Formatting
I am using a matrix to show multiple measures per a dimension, but I want to visualize these as bars instead of the values. I can of course do this via selecting show data bars in conditional formatting, but what I am seeing is there isn't much space between the bars in the columns for the max value. So what I want to do is create some buffer by adjusting the max value in the condition, but I need to do this dynamically, i.e. add a % to the Max value for the measure to generate this buffer. (Since there isn't column padding available in the formatting) Is this possible? Here's where I want to add some space:
1 Reply
- amitchandakSuper User
Anonymous , There is not much you can do with bar condutional formatting. You can try manually changing the size of column. But I doubt it will auto adjust
Please provide your feedback comments and advice for new videos
Tutorial Series Dax Vs SQL Direct Query PBI Tips
Appreciate your Kudos.