Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
8 years ago
Solved

Modify y-axis unit type in diagram

Hello together,   I'm a pretty new Power Bi User, so maybe my problem will be quickly solved. I would like to edit some units to my diagrams ( like [hour] , [pieces] or [liter] ) Unfortunately I ...
  • Anonymous's avatar
    Anonymous
    8 years ago

    Hi Anonymous,

     

    I think you can try to rename visual field name to add unit.(notice: it not effect the original column name)

     

    Sample: Amount to Amount (units)

     

    Regards,

    Xiaoxin Sheng

Anonymous's avatar
Anonymous
Not applicable
8 years ago

Hi Anonymous,

 

As I mentioned, current visual not support text value in value field. 

For your requirement, you can create a unit convert table.(e.g.g In water table, it store liquid with 'Milliliter' unit)

 

Sample:

Name, Rate
Milliliter,1
liter, 0.001
Gallon,0.00026

 

Then you can add a slicer to choose unit and write a measure to dynamic transfer unit.

 

Measure:

dynamic =
VAR selected =
    SELECTEDVALUE ( UnitTransform[Name] )
VAR unit_rate =
    LOOKUPVALUE ( UnitTransform[Rate], UnitTransform[Name], selected )
VAR current_value =
    MAX ( Watertable[Water] )
RETURN
    current_value * MIN ( unit_rate, 1 )

 

Regards,

Xiaoxin Sheng

Anonymous's avatar
Anonymous
Not applicable
8 years ago

Hi Anonymous,

 

thank you very much! It works and of course this is a solution to show the units per diagram.

But in my report I have different diagrams with different units. So using different slicers would look really confusingly.

 

I thought it would be much easier to make some units visible. I guess there's no other solution?

 

Regards,

 

Sven

  • Anonymous's avatar
    Anonymous
    Not applicable
    8 years ago

    Hi Anonymous,

     

    I think you can try to rename visual field name to add unit.(notice: it not effect the original column name)

     

    Sample: Amount to Amount (units)

     

    Regards,

    Xiaoxin Sheng

    • Anonymous's avatar
      Anonymous
      Not applicable
      8 years ago

      Hi Anonymous,

       

      i guess this is the easiest way!

      Thank you very much for that!

       

      BR,

       

      Sven

      • BeoStyx's avatar
        BeoStyx
        New Member
        6 years ago

        In his picture it's at the bottom of the menu: "Show value as", but that does not show up for me!  I guess the question now is, how do you get that to show up as a menu choice?