Forum Discussion

Pikachu-Power's avatar
Pikachu-Power
Impactful Individual
2 years ago

add bar chart an additional value

Hi all,

 

i have a bar chart and i want to assign to the first of the month a value of 900 for Typ = A, Segment = B and Code = C. My current measure is:

 

measure_exits =
VAR _begin_month = STARTOFMONTH(Calender[Date])
RETURN
      IF( MAX(Calender[Date]) = _begin_month &&
          MAX(Table[Typ]) = "A" &&
          MAX(Table[Segment]) = "B" &&
          MAX(Table[Code]) = "C", 900, [exicts])
 
But at the moment i only see the exits and not the 900 😐 Just when i filter Typ = A, Segment = B and Code = C i see the result 900. 
 
What i want to see are the exits and the 900 for the first of the month when nothing is filtered. When something is filtered i want to see the exicts and in case of Typ = A, Segment = B and Code = C the 900.
 
Some ideas? Maybe i have to work with SELECTEDVALUE, ALLSELECTED? Somehow out of practise. 
Need Help

3 Replies

  • Pikachu-Power's avatar
    Pikachu-Power
    Impactful Individual
    2 years ago

    I started some attempts yesterday but seems not as easy as i thought?

  • Anonymous's avatar
    Anonymous
    Not applicable
    2 years ago

    Hi Pikachu-Power ,

    In order to better understand your demands and give the right solution, could you please provide some more specific information? such as your desensitized example data and a screenshot of your desired results?

    Thanks for your efforts & time in advance.

     

    Best regards,
    Community Support Team_Binbin Yu
    If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

  • Pikachu-Power's avatar
    Pikachu-Power
    Impactful Individual
    2 years ago

    I have three slicers at the canvas: Typ, Segment and Code. What i want to see looks like:

     

     

    Always -900 exits for the first of the months. This -900 is initially just a dummy variable. The meaning doesnt matter. I want to make it dynamic later.

     

    Problem: when i use the measure

     

    measure_exits =
    VAR _begin_month = STARTOFMONTH(Calender[Date])
    RETURN
          IF( MAX(Calender[Date]) = _begin_month &&
              MAX(Table[Typ]) = "A" &&
              MAX(Table[Segment]) = "B" &&
              MAX(Table[Code]) = "C", 900, [exicts])

     

    i dont see this picture. The -900 will be only displayed when i filter Typ = A, Segment = B and Code = C. But when nothing is filtered the -900 should be shown also.

     

    Hope i could explain it better. I do something like a data addition with a measure and maybe thats the problem.

     

    Or say in other words: I want to expand my data for Typ = A, Segment = B and Code = C with these -900 and the filters should respond as usual.