Cannot toggle between log+linear scale

[Macc-PA]

I have a histogram chart show a measure (sales) against product name.

In order to show the sales as a log scale I have had to set the min value for the y-axis to1 - other It wont let me select log scale.

I have then tried to toggle between log and liner as follows:

• create a slicer with values log and linear
• create a measure (scaletype) whose value is blank if the user selects log and 0 if the user selects linear
• I have added that measure in the value field in my chart. ie both I have both 'sales' and 'scaletype' in the values field

The problem I have is that the scale does not toggle from log to linear even when the scaletype is zero.

I have checked that the scaletype value is correct by dispalying it in a card as well as looking at the chart data as a table.

Has anyone come across this problem or have a solution?

[Anonymous]

Hello @Macc-PA 
You can refer to this link 

[Pragati11]

Hi @Macc-PA ,

You will need add more details to yhe issue you are facing. You haven't added any screenshots that may have made it easy to understand.

https://community.powerbi.com/t5/Desktop/How-to-Get-Your-Question-Answered-Quickly/m-p/1447523

Just reading to your description and with limited understanding - One solution for your scenario could be to use Bookmarks to toggle between the charts. You can refer folloiwng to check how this can be done in Power BI:

https://community.powerbi.com/t5/Community-Blog/Toggle-Between-Charts-in-Power-BI/ba-p/1345014

Thanks,

Pragati

[amitchandak]

@Macc-PA , How are you trying to toggle.

Have you created two visual and toggle using boomarks ?

https://radacad.com/bookmarks-and-buttons-making-power-bi-charts-even-more-interactive