Group a measure in Multiple axes chart by XViz

[mrclay82]

Hi,

I have a measure that shows last week as a dot in a line and stacked column chart with the following measure:

IF(

    HASONEVALUE( 'Dim - Date'[Yearweek] )

    ,IF(

        VALUES( 'Dim - Date'[Yearweek] )

            = LOOKUPVALUE(

                'Dim - Date'[Yearweek]

                ,'Dim - Date'[Date]

                ,TODAY()-7

            )

        ,[Total units (Packages)]*1.1

    )

)

For other reasons I need to convert the chart to the Multiple axes chart by XViz.

But by doing so the dot is split by category (based on the legend), see below.

How can I rewrite the measure to only show one dot for the total as the previous image?

Thanks!

[tamerj1 · Accepted solution]

Hi @eliasayyy 
Please try

Last week 2 =
CALCULATE ( [Last Week], ALL ( 'Product'[Product Group] ) )

[mrclay82]

That solved it! Many thanks to you sir!

[eliasayyy]

what are the multiple axis can you please elaborate

[mrclay82]

[eliasayyy]

custom visuals might make thjis hard if you use field parameter on your mrasure and ceate a slicer to switch the axis, yo ucan use switch function to make it easy

to create a field paramter, go to modeling on your toolbar, seelcted new paramter, select field, insert your measures, add slicer and make it single select ,

add the field paramter column to your axis

you can now switch axis with the slicer

alter the measure

t = IF(

    HASONEVALUE( 'Dim - Date'[Yearweek] )

    ,IF(

        VALUES( 'Dim - Date'[Yearweek] )

            = LOOKUPVALUE(

                'Dim - Date'[Yearweek]

                ,'Dim - Date'[Date]

                ,TODAY()-7

            )

        ,SWITCH(

            SELECTEDVALUE('Your Field Parmeter Table'[Order]),

            0,[Total units (Packages)]*1.1,

            1,[Last Week] *1.1

        )

    )

))

[mrclay82]

Thanks,

Field parameters is somehow restricted at our company so I cannot create one.
Is there any other way than field parameter?

[eliasayyy]

no its usually turned off ,
go to file, options and settings, options global the, preview feautures and enable field paramters

[mrclay82]

Already turned on but nevertheless greyed out. No one have ever been able to tell me why but for some reason we cannot use field parameters:

[mrclay82]

@eliasayyy  same for power query, cannot be accessed in our dataset, if that has something to do with it.

[eliasayyy]

oh thats very wierd i am sorry i am unable to help you more i hope someone else can help 

@tamerj1 @FreemanZ @johnt75 

[mrclay82]

You have been very helpful although, thanks for taking the time!