Forum Discussion

rwong1's avatar
rwong1
Icon for Helper III rankHelper III
2 years ago
Solved

Card Visual to show nothing

Hi,   I'm trying to get a card visual that contains the growth data to not show anything if NO month is selected.  I tried alot of things and it still didn't work.  I just want to have my card visu...
  • Anonymous's avatar
    Anonymous
    2 years ago

    Hi rwong1 ,

     

    Update the measure.

    revenue growth value =DIVIDE(([Actual Revenue]-[Actual Sales QTD Previous]),[Actual Sales QTD Previous])

    If you want to select the year slicer or select the quarter slicer or select the month slicer to display the revenue growth value:

    Measure = SWITCH(TRUE(),
ISFILTERED('Date'[Year])=TRUE(),[revenue growth value],
ISFILTERED('Date'[QUARTER])=TRUE(),[revenue growth value],
ISFILTERED('Date'[Month])=TRUE(),[revenue growth value])

    If you want to select both the year and quarter slicers to display the revenue growth value:

    Measure 2 = IF(ISFILTERED('Date'[Year])=TRUE() && ISFILTERED('Date'[QUARTER])=TRUE() ,[revenue growth value],BLANK())

    If the above one can't help you get the desired result, please provide some sample data in your tables (exclude sensitive data) with Text format and your expected result with backend logic and special examples. It is better if you can share a simplified pbix file. Thank you.

     

    Best Regards,

    Neeko Tang

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

     

     

     

Anonymous's avatar
Anonymous
Not applicable
2 years ago

Hi rwong1 ,

 

According to your description, here are my steps you can follow as a solution.

(1)  We can create a measure. 

Measure = IF(ISFILTERED('Date'[Month])=FALSE(),BLANK(),DIVIDE(([Actual Revenue]-[Actual Sales QTD Previous]),[Actual Sales QTD Previous]))

or:

Measure = IF(SELECTEDVALUE('Date'[Month])=BLANK(),BLANK(), DIVIDE(([Actual Revenue]-[Actual Sales QTD Previous]),[Actual Sales QTD Previous]))

(2) Then the result is as follows.

 

If the above one can't help you get the desired result, please provide some sample data in your tables (exclude sensitive data) with Text format and your expected result with backend logic and special examples. It is better if you can share a simplified pbix file. Thank you.

 

Best Regards,

Neeko Tang

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

rwong1's avatar
rwong1
Icon for Helper III rankHelper III
2 years ago

Hi,

 

It didn't work.  It showed BLANK no matter what the situation is even if I had quarter and year selected.  I'll try to get you over a pbix file.

  • Dangar332's avatar
    Dangar332
    Icon for Resident Rockstar rankResident Rockstar
    2 years ago

    Hi, rwong1 

    Try below one 

     IF(ISFILTERED('Date'[Month])=FALSE(),if(isfiltered('date'[year] )|| isfiltered'(date'[quarter]),DIVIDE(([Actual Revenue]-[Actual Sales QTD Previous]),[Actual Sales QTD Previous]),blank()),blank())

     

     

     

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