Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
4 years ago
Solved

need help

Hi All,

          i need your help as i need to create a textbox/card which has to show the data what ever is getting selected from Silcer.for example if i select satart date and end date from silcers i need these selections to be shown in the text box as well.could someone please let me know how to do this in power bi desktop.

 

 

Regards

Anitha 

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

    Hi Anonymous ,

    You can get it by a measure and a card visual, here's my solution.

    Create a measure.

    Measure =
FIRSTDATE ( 'Date'[Date] ) & "-"
    & LASTDATE ( 'Date'[Date] )

    Get the correct result. Here, you can modify the font size and turn off the category label in the formatting pane.

    I attach my sample below for reference.

     

    Best Regards,
    Community Support Team _ kalyj

    If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

1 Reply

  • v-yanjiang-msft's avatar
    v-yanjiang-msft
    Community Support
    4 years ago

    Hi Anonymous ,

    You can get it by a measure and a card visual, here's my solution.

    Create a measure.

    Measure =
FIRSTDATE ( 'Date'[Date] ) & "-"
    & LASTDATE ( 'Date'[Date] )

    Get the correct result. Here, you can modify the font size and turn off the category label in the formatting pane.

    I attach my sample below for reference.

     

    Best Regards,
    Community Support Team _ kalyj

    If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.