Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
5 years ago

Merge measure for text display with dynamic visuals

Hi all,

following issue: 

I can change what`s displayed in my visual via a slicer (Cont of Documents, Euro Value, Local Value).

I am now required to display what Unit is used but in the visual itself! So I can't just make a card somewhere in the page where I display it, is has to be displayed in the visual itself (so it doesn't disappear when you apply Focus mode onto a visual).

 

I tried it using the following function:

 

Amount Sales Docs& Net Value =
SWITCH(TRUE(),
VALUES('Measure Dimensions'[Measure])= "Count", CONCATENATE([Unit Display],[C Amount of Sales Orders]),
VALUES('Measure Dimensions'[Measure])= "Local Currency", CONCATENATE([Unit Display], [LC Net Value]),
Values('Measure Dimensions'[Measure])= "Euro Value", CONCATENATE([Unit Display],[€ Net Value]),
BLANK())
 
For this a few hints:
The measure "Unit Display" already successfully shows me the displayed Unit when I apply it onto a card.
The other measures work just fine as well
The whole functions also works if I remove the "CONCATENATE([Unit Display]),", just when I try to integrate it, it won't work and shows "No data to be displayed" 
ANyone an idea for a workaround? Ideally where you can determine the format and position of the text ?
Need Help

12 Replies

    • Anonymous's avatar
      Anonymous
      Not applicable
      5 years ago

      Dear   unfortunately that isn't what I'm looking for...
       
      To be precise I already implemented that kind of slicers (modified to match my needs) and they work just fine. 
      I can't insert pictures here for whatever reason so I'll try describe my issue as detailed as possible:
       
      Like said I've already implemented that feature in my pie charts and it works. Therefore I used the following code:
      "
      Amount Sales Docs& Net Value =
      SWITCH(TRUE(),
      VALUES('Measure Dimensions'[Measure])= "Count", [C Amount of Sales Orders],
      VALUES('Measure Dimensions'[Measure])= "Local Currency", [LC Net Value],
      Values('Measure Dimensions'[Measure])= "Euro Value", [€ Net Value],
      BLANK())"
       
      However, I need the same pie chart with the one difference of it having a small box on the bottom left corner that says: "Displayed Unit: Pieces of/Euro/[Local Currency". 
      I've already made a measure that does this and tested it in a card. So when the slicer is on "Euro" It says "Euro", when its on "Count" it says "Pieces of" etc. I called the measure "Unit display".
       
      Now, I somehow need to merge that measure "Unit Display" with the measure "Amount of Sales Docs. and Net Value", so that it tells me the Unit in my pie chart. I can't just put the box over the visual, cause if some looks at it in "Focus mode" then, it will disappear.
       
      I tried achieving my goal using the measure:
      "Amount Sales Docs& Net Value =
      SWITCH(TRUE(),
      VALUES('Measure Dimensions'[Measure])= "Count", CONCATENATE([Unit Display],[C Amount of Sales Orders]),
      VALUES('Measure Dimensions'[Measure])= "Local Currency", CONCATENATE([Unit Display], [LC Net Value]),
      Values('Measure Dimensions'[Measure])= "Euro Value", CONCATENATE([Unit Display],[€ Net Value]),
      BLANK())"
       
      but that didn't work and now I'm trying to overcome that hurden...