Forum Discussion

mdaamirkhan's avatar
mdaamirkhan
Icon for Post Prodigy rankPost 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 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 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()
    )

2 Replies

  • Eric_Zhang's avatar
    Eric_Zhang
    Icon for Microsoft Employee rankMicrosoft Employee

    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()
    )