Forum Discussion

jjustjjo's avatar
jjustjjo
Icon for Helper II rankHelper II
5 months ago

Parameter controlled visual and filtering the tooltip

I have a simple stacked column chart  that changes based on a parameter:  I have a tooltip, but it filters down to just the quarter when viewed by Quarter: By Year it does show a...
Need Help
v-ssriganesh's avatar
v-ssriganesh
Icon for Community Support rankCommunity Support
5 months ago

Hello jjustjjo,

Hope everything’s going great with you. Just checking, the issue been resolved or are you still running into problems? Sharing an update can really help others facing the same thing.

Thank you.

jjustjjo's avatar
jjustjjo
Icon for Helper II rankHelper II
5 months ago

Hi v-ssriganesh 
I'm able to duplicate your results in your simplified version with the added complexity of making the tooltip look like this: 

However, when I apply these changes to my full more complicated version, I still get this when hoving over a completed section of the bar:

and this when hovering over the Active section of the bar: 

Note that your View by differs from mine (yours on the bottom in this image):

This because multiple years can be displayed.  I can't use just quarter.  I have an added column for sorting Active-Completed; I also am sorting View-by by it's sort column.  So, for example, my definition for In Progress on the Tooltip looks like this:

All my TT formulas remove those four filters and include the treatas statement.  The counts are correct, but I can't all four quarters to show in the quarter view.  Even going to a simplified tooltip that only contains 

I still only get the hovered quarter showing.



In addition, I am completely gobsmacked by the following (although not as important as the original request).  I took a copy of your earlier version that I had modified and modified it to match your newer one.  I have painstakingly reviewed all formulas, table defs, etc., to confirm that are identical.  This is my result:

Note that the top version is the earlier version you sent that I modified ( I just used a slightly different table name for the quarter table.  I used your exact definition.  Not the completed counts on the earlier version are different.

There are a few other mods I've made, but they are in both versions identically:

 

 

  • jjustjjo's avatar
    jjustjjo
    Icon for Helper II rankHelper II
    5 months ago

    v-ssriganesh 
    I just unearthed one thing.  In the above images, the Not Linked counts always shows.  This is apparently because the the formula references 3 others: Active CERs, Total Completed Count, Count In Progress, Count Pending. These formulas either or both [Active-Completed] and [Completion Timing] in their formulas.  I'll mess  around with those and post an update if I figure anything out.

     

    • jjustjjo's avatar
      jjustjjo
      Icon for Helper II rankHelper II
      5 months ago

      v-ssriganesh I managed to get most of the tooltip formulas working so that the numbers always showed (except for one).  But they still only show for the quarter being hovered.  If I ViewBy Year, it does show all four quarters.  Guess the user will have to be happy with that.  I have a July deadline and another 20 some reports to convert.

      • MFelix's avatar
        MFelix
        Icon for Super User rankSuper User
        5 months ago

        Hi jjustjjo ,

         

        Apologies to everyone for jumping in this post but I saw your message in the How To get your answer post.

         

        This is concerning the context of the quarter so in this case you are doing a filter at year or quarter and then getting the tooltip to display that value since the visualization you have is filtered at the quarter level the tooltip will also give that specifc value.

         

        From the post it appears to me that you have a calendar table that you use for the calculations.

         

        I have done the following:

        • Created a disconnected table for quarters (in this case in text format) similar to the one on the calendar table

         

        • Add the following measure:
        Toolttip Total Sales =
        CALCULATE(
                [Total Sales], 
                REMOVEFILTERS('dim Calendar'[QtrText]), 
                'dim Calendar'[QtrText] = SELECTEDVALUE(Disconnectd[QtrText]))
        • Create your matrix on the tooltip in the following manner:
          • Rows:
            • Year (Calendar Table)
            • Quarter ( Disconnected Table)
          • Values:
            • Tooltip Measure

        The result is below:

         

         

         

         

        Has you can see the values match the columns in the example I also added on the tooltip page the selected value of the quarter from the calendar table so you could see the selected quarter, I have done the example for a bar chart and also for a matrix so you could check that the result is the same.

         

        Be aware that based on your model you could have to make adjustments to the calculation because the context is impacted by a lot of variables but this should work.

         

        Regarding your question about sharing files you are correct about not being able to attach files, since only a few specific users profiles can do it because of security questions but that can be done using a onedrive, google drive, we transfer or similar link to upload your files.

        Please let me know if this works on your model.