Forum Discussion
Cannot toggle between log+linear scale
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?
3 Replies
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
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
