Forum Discussion

ofrede's avatar
ofrede
New Member
4 years ago
Solved

Multiple Y-axis from Cube data

Hi,   I have a cube to which I connect. It has a rather simple fact with some meassures:   Prices: Date Value   The Index is then connected to my Commodities dimension: Commodities: Name  ...
Need Help
  • Anonymous's avatar
    Anonymous
    4 years ago

    Hi ofrede ,

     

    You may try to add a measure to "seperate" the smallest and the biggest value like this:

    Secondary = 
var _sum=SUM('Table'[Value])
return IF(_sum<2,_sum,BLANK())

     

    Or enable the Zoom slicer options:

     

    Best Regards,
    Eyelyn Qin
    If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

Anonymous's avatar
Anonymous
Not applicable
4 years ago

Hi ofrede ,

 

You may try to add a measure to "seperate" the smallest and the biggest value like this:

Secondary = 
var _sum=SUM('Table'[Value])
return IF(_sum<2,_sum,BLANK())

 

Or enable the Zoom slicer options:

 

Best Regards,
Eyelyn Qin
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

ofrede's avatar
ofrede
New Member
4 years ago

Solution accepted!

 

And it gave me the hint for an even better solution (in my case)!
I have my data in groups (Fruits, Small vehicles, Large vehicles) which I can then filter on instead of the value.

So based on my real-life example, I have created a few new measures like this one:

Fruit =CALCULATE(sum(Commodities[Value]),CommoditySpec[Group]="Fruit")