Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
4 years ago
Solved

Tachometer by Annik

Ich habe eine Visualisierung mit einem Tachometer erstellt. Dieser zeigt mir meinen Kassenbestand an. Sofern ich keine Datumsauswahl treffe nimmt der Tachometer automatisch die Summe von allen meinem Kassenwerten. Hier möchte ich allerdings bei keiner Datumsauswahl den Endwert meines Kassenbestands angezeigt haben. Als Vergleich gibt beispielsweise die KPI Visualisierung den Endwert der Datenreihe aus. Dies möchte ich auch so im Tachometer darstellen. Vielen Dank 

 

I created a visualization with a tachometer. This shows me my cash balance. If I don't make a date selection, the tachometer automatically takes the sum of all my cash values in the callout value (5.33M). Here, however, I want to have the final end value of my cash balance displayed if I do not select a date value (0.23 Mio. €). As a comparison, for example, the KPI visualization (below the Tachometer) outputs the final end value of the data series (0.23 Mio. €). I would also like to represent this case in the tachometer visualization. Many Thanks.

 

Need Help
  • v-janeyg-msft's avatar
    v-janeyg-msft
    4 years ago

    Hi, Anonymous 

     

    If I understand what you mean, I think you can create a measure and put it in 'value' field.

    Like this:

    measusre =
IF ( ISFILTERED ( table[Date] ), 0.23, SUM ( table[Value] ) )
//0.23 means calculate 0.23's logic
    Did I answer your question? Please mark my reply as solution. Thank you very much.
    If not, please feel free to ask me.
     
    Best Regards,
    Community Support Team _ Janey

4 Replies

  • v-janeyg-msft's avatar
    v-janeyg-msft
    Icon for Community Support rankCommunity Support
    4 years ago

    Hi, Anonymous 

     

    If I understand what you mean, I think you can create a measure and put it in 'value' field.

    Like this:

    measusre =
IF ( ISFILTERED ( table[Date] ), 0.23, SUM ( table[Value] ) )
//0.23 means calculate 0.23's logic
    Did I answer your question? Please mark my reply as solution. Thank you very much.
    If not, please feel free to ask me.
     
    Best Regards,
    Community Support Team _ Janey
    • Anonymous's avatar
      Anonymous
      Not applicable
      4 years ago

      Hi @Support Team _ Janey,

       

      thank you for your correct solution!

       

      Lukas

  • Anonymous's avatar
    Anonymous
    Not applicable
    4 years ago

    Pragati11 

    Hi Pragati,

    thank you for your response. I add a picture and some numbers. I hope you can understand my question and issue. 

    Lukas