Forum Discussion

jcastr02's avatar
jcastr02
Post Prodigy
6 years ago
Solved

remove visual when there is no data

I have a silcer that when I click on certain assessment titles, they don't have as many questions as the other, as example below, the OPE Overview only has 10 questions, how can I make 11-15 dissappe...
Need Help
  • vivran22's avatar
    vivran22
    6 years ago

    Hello jcastr02 

     

    Try this:

     

    Measure 1 (Column): 

    Avg Points = AVERAGE('Performance by Question'[Points])

     

    Measure 2 (Line):

    Score Goal = IF(ISBLANK([AVg Points]), BLANK(),.8)

     

    Regards,
    Vivek

    If it helps, please mark it as a solution

    Kudos would be a cherry on the top 🙂

    https://www.vivran.in/
vivran22's avatar
vivran22
Community Champion
6 years ago

Hello jcastr02 

 

Try this:

 

Measure 1 (Column): 

Avg Points = AVERAGE('Performance by Question'[Points])

 

Measure 2 (Line):

Score Goal = IF(ISBLANK([AVg Points]), BLANK(),.8)

 

Regards,
Vivek

If it helps, please mark it as a solution

Kudos would be a cherry on the top 🙂

https://www.vivran.in/
jcastr02's avatar
jcastr02
Post Prodigy
6 years ago

Thanks vivran22  this workeD!