topic Re: Group a measure in Multiple axes chart by XViz in DAX Commands and Tips

Group a measure in Multiple axes chart by XViz

mrclay82 — Fri, 28 Apr 2023 07:44:35 GMT

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!

Re: Group a measure in Multiple axes chart by XViz

eliasayyy — Fri, 28 Apr 2023 08:57:04 GMT

what are the multiple axis can you please elaborate

Re: Group a measure in Multiple axes chart by XViz

mrclay82 — Fri, 28 Apr 2023 09:08:42 GMT

Re: Group a measure in Multiple axes chart by XViz

eliasayyy — Fri, 28 Apr 2023 09:25:58 GMT

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

)

))

Re: Group a measure in Multiple axes chart by XViz

mrclay82 — Fri, 28 Apr 2023 09:33:00 GMT

Thanks,

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

Re: Group a measure in Multiple axes chart by XViz

eliasayyy — Fri, 28 Apr 2023 09:40:55 GMT

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

Re: Group a measure in Multiple axes chart by XViz

mrclay82 — Fri, 28 Apr 2023 09:45:10 GMT

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:

Re: Group a measure in Multiple axes chart by XViz

mrclay82 — Fri, 28 Apr 2023 09:47:49 GMT

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

Re: Group a measure in Multiple axes chart by XViz

eliasayyy — Fri, 28 Apr 2023 09:50:12 GMT

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

tamerj1 FreemanZ johnt75

Re: Group a measure in Multiple axes chart by XViz

mrclay82 — Fri, 28 Apr 2023 09:55:00 GMT

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

Re: Group a measure in Multiple axes chart by XViz

tamerj1 — Fri, 28 Apr 2023 10:34:44 GMT

Hi eliasayyy
Please try

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

Re: Group a measure in Multiple axes chart by XViz

mrclay82 — Thu, 04 May 2023 07:21:16 GMT

That solved it! Many thanks to you sir!