Forum Discussion

maibacherstr's avatar
maibacherstr
Icon for Helper III rankHelper III
3 years ago

Set the Default View of a Visual

Hello, trying to solve the following problem, trying to think outside the box and welcome all suggestions...   On my report page, I have a line graph that's easy to misinterpret *until* the user se...
Need Help
Show and Tell
Tips and Tricks
vicky_'s avatar
vicky_
Icon for Super User rankSuper User
3 years ago

Is there some way you can make the measure in the line graph not show anything until a row in the table is selected with the HASONEVALUE()?

I think something like this could work:

LineGraphMeasure = IF(HASONEVALUE([Table Column]), 
    // calculations here, 
   BLANK()
)

And you can probably change the line graph title to a measure like: 

LineGraphTitle = IF(HASONEVALUE([Table Column]), 
    "Showing Details for " & SELECTEDVALUE([Table Column]), 
   "Please select a row from Table Name"
)

in case they get confused on why the line graph isn't showing.

 

The other way is to publish the report with a default selection in the table, and then uncheck the persisten filters in the report settings. 

 

  • maibacherstr's avatar
    maibacherstr
    Icon for Helper III rankHelper III
    3 years ago

    Thanks! This is obviously a great start, I just haven't been able to translate it yet. Sorry I just need to pin this down more specifically...

    LineGraphMeasure = IF(HASONEVALUE([Table Column]), 
    // calculations here, 
   BLANK()
)

    Between my line graph and table visual, I think [Table Column] would basically be the title column used in the table visual -- is that correct?

    As for the 'calculation' I'm even more lost.

    At the end I'll add this measure as a filter on the line graph.

     

    I would tremendously appreciate a little more detail, thanks again.