Forum Discussion

mdaamirkhan's avatar
mdaamirkhan
Post Prodigy
9 years ago
Solved

Dynamix Change Axis not working

I have created one Dynamix Change Axis in my report with "Value and Volume" If I select "Value" then it will show Value figures and If I select "Volume" then it show Volume Figure but figures are not...
Need Help
Show and Tell
  • Eric_Zhang's avatar
    Eric_Zhang
    9 years ago
    mdaamirkhan wrote:

    I have created one Dynamix Change Axis in my report with "Value and Volume" If I select "Value" then it will show Value figures and If I select "Volume" then it show Volume Figure but figures are not showing. Can you please me on this I have shared the pbix file link: https://drive.google.com/open?id=0BxreilNC4AvsUDdPa296NENNN3M

    I select VolumeVolume Figure is not showing

     

    Thanks 

    Aamir

    mdaamirkhan

    Try to modify below measure.

    Axis Dimension Selected = 
IF (
    HASONEVALUE ( DimTable[AxisDimension] ),
    LASTNONBLANK(DimTable[AxisDimension],""),BLANK()
)

Eric_Zhang's avatar
Eric_Zhang
Microsoft Employee
9 years ago
mdaamirkhan wrote:

I have created one Dynamix Change Axis in my report with "Value and Volume" If I select "Value" then it will show Value figures and If I select "Volume" then it show Volume Figure but figures are not showing. Can you please me on this I have shared the pbix file link: https://drive.google.com/open?id=0BxreilNC4AvsUDdPa296NENNN3M

I select VolumeVolume Figure is not showing

 

Thanks 

Aamir

mdaamirkhan

Try to modify below measure.

Axis Dimension Selected = 
IF (
    HASONEVALUE ( DimTable[AxisDimension] ),
    LASTNONBLANK(DimTable[AxisDimension],""),BLANK()
)