Forum Discussion
Helper IIICard 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 visual show nothing or blank or NA if the month slicer is not selected. If the year and quarter slicer is selected I want the card visual to show the revenue growth value. I tried:
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.
4 Replies
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.
rwong1Hi,
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
Resident Rockstar
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
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.
