cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
jtgriffith Frequent Visitor
Frequent Visitor

Bar chart log scale

I created a horizontal bar chart with a drill down feature. The visualization shows the quantity of products sold at different levels of classification hierarchies. 

 

I need to use a logarithmic scale on the x-axis, but that doesn't appear to be an option (the only option is "linear" for "Scale Type").

 

If I change the visualization type to "Line Chart", then I have the option of a Log Scale. 

 

Is this feature just not implemented yet?

 

1 ACCEPTED SOLUTION

Accepted Solutions
Moderator v-qiuyu-msft
Moderator

Re: Bar chart log scale

Hi @jtgriffith,

 

Based on my research, Log scale type is not available in bar charts and column charts currently.

 

Best Regards,
Qiuyun Yu

 

 

Community Support Team _ Qiuyun Yu
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

View solution in original post

5 REPLIES 5

Re: Bar chart log scale

I don't work for Microsoft so I don't know if it not implemented yet or deliberatly left out but generally speaking all types of visuals have or can have different attributes. An attribute on one type of visual does not have to be on other type of visuals. So even though there is log scale on the line graph there might never be one on the bar chart. 

 

If you need it and think it makes sense you should submit it as an idea at ideas.powerbi.com and try to get people to vote it up.

dedelman_clng New Contributor
New Contributor

Re: Bar chart log scale

Try a column chart and see if that gives you the log option on Y-axis.

Moderator v-qiuyu-msft
Moderator

Re: Bar chart log scale

Hi @jtgriffith,

 

Based on my research, Log scale type is not available in bar charts and column charts currently.

 

Best Regards,
Qiuyun Yu

 

 

Community Support Team _ Qiuyun Yu
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

View solution in original post

Hikmer Regular Visitor
Regular Visitor

Re: Bar chart log scale

Unreal this isn't implemented....beyond disappointing.  Everything needs to be voted on when somethign so obvious should be done???

Highlighted
cyclist007 Member
Member

Re: Bar chart log scale

The log axis option in bar charts is available after you enter 1 for the minimum value. See image below:

 

Log Scale in column chart.PNG

 

Credit to this post: http://community.powerbi.com/t5/Desktop/Is-logarithmic-scale-in-power-BI-possible/m-p/134138/highlig...

 

This should have been automatic, not required manual entry for minimum value!

Helpful resources

Announcements
New Topics Started Badges Coming

New Topics Started Badges Coming

We're releasing new versions of the badge that everyone's talking about. ;) Check your inbox for notifications.

MBAS 2020

Save the new date (and location)!

Our business applications community is growing—so we needed a different venue, resulting in a new date and location. See you there!

Difinity Conference

Difinity Conference

The largest Power BI, Power Platform, and Data conference in New Zealand

Top Solution Authors
Top Kudoed Authors (Last 30 Days)
Users online (1,260)