Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
8 years ago
Solved

Blank Text Card until something selected in a slicer

Hi   I have a report with multiple slicers and I am using a text card to show the name of the account selected. When the user doesnt select anything it is showing the first account name. How can I ...
Need Help
v-frfei-msft's avatar
v-frfei-msft
Icon for Community Support rankCommunity Support
8 years ago

Hi Anonymous,

 

Here I made a sample to meet your requirement. We can create a measure like this to get the the result as we excepted.

 

Measure = IF(ISFILTERED(Table1[name]) || ISFILTERED(Table1[Plant]) || ISFILTERED(Table1[VAS type])||ISFILTERED(Table1[date]),FIRSTNONBLANK(Table1[name],Table1[name]),BLANK())

 

 

For more details, please check the pbix as attached.

 

https://www.dropbox.com/s/axa0yq95rvm8itk/Blank%20Text%20Card%20until%20something%20selected%20in%20a%20slicer.pbix?dl=0

 

Regards,

Frank

  • andreaabisaab's avatar
    andreaabisaab
    Regular Visitor
    6 years ago

    hi v-frfei-msft 

     

    this has worked perfectly for me, thanks! 

     

    I have made a little change in your expression, because i didn't want " (Blank) " to appear on my card, so here's the expression I used: 

     

    Measure = IF(ISFILTERED(Table1[name]) || ISFILTERED(Table1[Plant]) || ISFILTERED(Table1[VAS type])||ISFILTERED(Table1[date]),FIRSTNONBLANK(Table1[name],Table1[name]),"")

     

    Thanks ! 🙂

    • Anonymous's avatar
      Anonymous
      Not applicable
      3 years ago

      Same thing I did as well.  Looks cleaner. 

  • v-frfei-msft's avatar
    v-frfei-msft
    Icon for Community Support rankCommunity Support
    8 years ago

    Hi Anonymous,

     

    Does that make sense? If so, kindly mark my answer as a solution to close the case.

     

    Regards,
    Frank

  • jimmy7377's avatar
    jimmy7377
    Frequent Visitor
    5 years ago

    Hello all

     

    I am trying to do somthing simlar but with a Card and the card normally hold dates so this is what I have 

    ProjectStartDateMeasure = if(HASONEVALUE(Table[Column), FIRSTDATE(Table[Column]),"Select Project")
    When nothing is selected I get Select Project but when i select a date i get 

    This has now taken to many hours, wall, head. you get the picture. Please someone put me out of misory pretty please.

     

    • yazenbarakat123's avatar
      yazenbarakat123
      Icon for Helper I rankHelper I
      4 years ago

      Did you ever Find the solution to this Issue? Running into something very similar 

    • yazenbarakat123's avatar
      yazenbarakat123
      Icon for Helper I rankHelper I
      4 years ago

      Try something like this ! 

          FORMAT(SELECTEDVALUE ( Dates[Date] ),"dd/mm/yyyy")

       

      it worked for me ! if so please accpet this as a valid solution as it would be my first 🙂 

      jimmy7377 

  • Arunsawas's avatar
    Arunsawas
    New Member
    3 years ago

    I try to used the same formula but the card appeared only Blank, it was not change while I selected other item? Do I have to put all the colum in the table or just the column that I used to make the whole project (including another tab)

  • Anonymous's avatar
    Anonymous
    Not applicable
    3 years ago

    Hi , This worked for me but at thi point it show blank . In case we want to display "Text" in Card instead of black when selected all then what will be the query?