Use of line and clustered column charts with representational bars

[ptepichin]

Hi,

I was using a line and clustered column chart in which i'm tracking the number of samples tested in a lab along the number of positive results and then using a line chart to trace the percentage of positive results per the total tested per day. The problem with that is that sometimes the number of samples tested can be considerably higher from one day to another, thus the bars are way too big or small. As an alternative I was thinking of having a representational graph where all bars are the same size. Is there a way to configure the graph to do so or is there another approach you would recommend based on the tools available on Power BI.  

[v-chuncz-msft · Accepted solution]

@ptepichin 

In the Format section of the Visualizations pane, expand the Y axis card and try setting Scale type.

[amitchandak]

Experiment by displaying log value sample tested

[ptepichin]

Thanks for the quick response 🙂 

Is that a configuration setting?

[amitchandak]

There are log and ln functions. Create new measure and try

[ptepichin]

Sorry, i'm new to Power BI. Is there a link online on how to it or has that question been posted prior?