Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
5 years ago

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

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