Forum Discussion

goalie_'s avatar
goalie_
Icon for Helper III rankHelper III
6 years ago

Log and Linear Scale slicer

Hi all,   I'm trying to be able to switch between log and linear scale for a bar chart using a slicer. Similary to what's shown in https://blog.mi4.com/analytics/power-bi-logarithmic-linear-axis/ s...
Need Help
Tips and Tricks
MFelix's avatar
MFelix
Icon for Super User rankSuper User
6 years ago

Hi goalie_ ,

 

there is a small trick that you need to do before making this work, you need to select the Y-axis and place the Scale as Log then add the measure for the selection of the slicer and eveything will work proper, however I must warn you that this look funny in a bar chart since there are two values for each bar and the x-axis is on the middle.

 

  • goalie_'s avatar
    goalie_
    Icon for Helper III rankHelper III
    6 years ago

    Hi MFelix , yes I understand that. I have a categorical x-axis and usage amount on the y-axis. I am not able to place the measure into the slicer at all. The measure I'm using is, which is slightly changed,

     

    LinLog = IF(SELECTEDVALUE('Scale'[ScaleType]) = "Linear", CALCULATE(sum(USAGE_AMOUNTS), CATEGORIES)*0,BLANK())
     
    I don't know if I changed it correctly. 
    • MFelix's avatar
      MFelix
      Icon for Super User rankSuper User
      6 years ago

      Hi goalie_ ,

       

      The measure is not to be placed in the slicer, you need to place the measure on the bar char as a value

      • goalie_'s avatar
        goalie_
        Icon for Helper III rankHelper III
        6 years ago

        I got it to work if I remove the value in legend. I am using a clustered column chart. I have a field in legend to diffrentiate the categories by location. I am unable to put the measure into the values if I have a field in legend. Is it still possible by tweaking the measure or am I out of luck?