Skip to main content

#Tableau Desktop & Web Authoring222 discussing

Hi Community, 

 

I would like to do something like this (just AI generated and other context): Goal is to show the whole range of a variable, the IQR as 25% and 75% percentile and one country.

Keep reference lines when filtering for one country

I managed it to create the reference lines, but as soon as I try to filter one country ("Land"), it does not keep them. I assume the calculation is changed to the visible country. But I would like to keep it to all the countries. Is this possible in tableau? See my workbook attached. 

image.png

 

Many thank for any help! 

Kind regards, Sarah 

 

 

#Tableau Desktop & Web Authoring

2 answers
  1. May 15, 2:12 PM

    @Sarah Rödger

     

    Hi, in this case you may: 

     

    a. Create a set on Land, and select Use all:

    Hi, in this case you may: a. Create a set on Land, and select Use all: b. Select a box plot viz, right clic on the axis, configure the reference line as: c.

     

    image.png

     

    b. Select a box plot viz, right clic on the axis, configure the reference line as: 

     

    image.png

     

    c. Create a Detailed calc:

    IF MAX([Land Set]) THEN SUM([tt_investment_per_emp_usd]) END

    d. Drag beside your current tt_investment pill in the rows shelf, dual axis and sinchronize axis 

     

    image.png

     

    e. Right clic on the set in the data pane, and select show set. 

    f. In the set control select one country. 

     

    Finally, it would be more a format challenging (Add a custom shape, add color, label, etc). 

     

    The custom shape I used: 

    image.png

     

    The final outcome: 

     

    image.png

     

    If this post resolves the question, would you be so kind to "Accept this Answer"?. This will help other users find the same answer/resolution and help community keep track of answered questions. Thank you. 

     

    Regards, 

     

    Diego Martinez 

    Tableau Visionary and Tableau Ambassador 

0/9000

I'm using Tableau Desktop (public edition) 2026.1.1 to edit multiple workbooks on my Win 11 workstation and the program is suddenly extremely laggy. Just selecting dashboard objects causes a multi-second delay where a blue circle spins and "Not Responding" appears in the status bar alongside the dashboard name at the top of the screen.  

 

Is anyone else experiencing this issue? I've edited these workbooks repeatedly without issue over the past few weeks, so I'm wondering if this might relate to the service outage 2 weeks ago that resulted in Error Code: 9F4C5638. 

 

I'd appreciate any input! 

 

#Tableau Public  #Tableau Desktop & Web Authoring

7 answers
  1. Yesterday, 9:40 AM

    Hi,Kathy Kaufman

     

    I’m also seeing similar behavior in 2026.1.1, where Tableau suddenly becomes slow and shows “Not Responding” for a few seconds. I haven’t seen anything official about a major issue, but it does feel more common than in previous versions. 

     

    In my case, the lag tends to appear after working for a long time or when the workbook gets heavier. Restarting Tableau or even rebooting Windows has helped, and cleaning up unused sheets or switching the dashboard size settings has also made things a bit smoother. 

     

    I’m also curious to hear if others are experiencing the same slowdown in this version.

0/9000

Hi Community 

 

Can actions run automatically?  Current selections are Hover, Select, Menu which requires the user to click to run it.  This vis is loaded into a client portal (there are over 2k clients) so when the client pulls up the report, it filters based on their OrgID.   

 

I’ve attached a watered-down package workbook with dummy data to see if Tableau can do this.  

The workbook was originally set up using the first dB (red color) called Comparison and when the developers embedded the code, they had to set a filter for OrgID in the embed code to work in the portal.  After it went live, the client asked for changes but I was not allowed to touch the Comparison dB so we are using that as an instruction landing page with a button having them click to go to the Comparison Metrics dashboard.   

 

When the vis moves to the Comparsion dB, the line chart on the left filters to their org and plots their dots.  The bar chart on the right is not active until they click their name in the line chart.  Then the bars sorts and puts their org at the top.  It works great but I’m hoping to make that bar chart work automatically so when they click the landing page button, the line and bar chart should update to their org.  On the bar chart we can’t put OrgID there because it filters to just that org.  Our goal is to show their org at the top and then sort all others below.  I’m using a set for that.   

For testing, you can change the OrgID at the top you will see what I mean that the bars don’t automatically update until they click the name in the line chart. 

Thank you! 

 

 

#Tableau Desktop & Web Authoring

16 answers
0/9000

I'm using the default device layouts for desktop and tablet, and a custom phone layout. 

 

When the screen width is smaller than about 900px, numbers begin to display as pound signs (see below). In other cases, where an element is set to "entire view," the right side of a container is cut off and there's no scrollbar available to shift the view.   

 

Ideally, I'd like the device layout to shift automatically to phone if the screen size is narrower than 900px. I'd also prefer to use the default device layouts (without customizations) so that I don't have to tweak and maintain multiple layouts for every dashboard I create.  

 

I'd appreciate any advice. TIA!   

Can we get layout to shift automatically when screen size is too narrow?

 

 

 

#Tableau Desktop & Web Authoring

5 answers
0/9000
4 answers
  1. Jun 20, 2024, 11:04 AM

    To have a dynamically updating legend showing the year, you'd need to create a worksheet to act as your legend. Something like this:

    To have a dynamically updating legend showing the year, you'd need to create a worksheet to act as your legend.

0/9000

Hi Team,

 

PFB screenshot - I Would like to remove circled boxes/lines from my visualization & want to display only measure names as headers and their respective bars.

 

Is there any way to achieve this?

Please assist

 

Removing Additional Lines  from Worksheet

2 answers
  1. Aug 4, 2022, 4:19 AM

    Hi @Santosh damisetty​ 

     

    Thank you so much for your response to my request.

    I also tried the same method via the format tab, however, it's not solving this issue.

    Finally, I achieved this post by replacing measures from columns with measure values.

     

    Thanks for your support!

     

    Regards,

    Veera Bezawada

0/9000

Hi Team,

 

PFB Image where I have created sheet with Three Filters by giving filter condition as "Apply to All worksheets using this data source".

Seeing Guidence to  enable Apply Click for multiple filters & Auto navigate to  another sheet.Also I have another sheet for Apply button by creating calculated filed as "Apply" and dragged this to ROWS, dragged required dimensions to DETAILS & MARKSCARD sheet type changed to Polygon. 

imageNow, Dashboard created by dragging "Apply" sheet and that filters as below and Filter Action applied by selecting "Apply" sheet as Source and Data sheet as Target.

Here I am looking to select the required fields from all three filters and want to click on the "Apply" button so that all three filters will apply at a time post my click only. However, whenever I selected each filter it's running automatically in the backend for each selection.

 

Is there any way that I can avoid filtering autorun and enable this APPLY button for all selected filters at a time?

2 answers
0/9000

Hi All,

PFB image where filter applied on Sub-category - I have measures like Sales, Discount & Profit.

 

I have applied %of total table calculation to Discount filed. Below image showing individual sub category wise discount % however If I select any one sub category from filter - Discount % showing as 100% instead of their actual value.

Table Calculation Method in Tableau 

 

Is there any calculation to fix this?

 

Please advise

2 answers
  1. Jul 25, 2022, 11:31 AM

    Hi @Veera Bezawada​, you have two options;

    a. Modify the calc. to LOD expression, see code snippet below;

    {FIXED [Subcategory]: SUM([Discount])}/{SUM([Discount])}

    b. Change the filter to TABLE calc. filter as shown below;

    LOOKUP(MIN([Sub-Category]),0)

    Use this in the filter instead of the Sub-category filter. I hope this helps.

0/9000

Hi Tableau Expert, I have a use case where I need to control multiple measure values in the single chart. 

So, let's say I want to show category wise sales and profit. Now I want user to have the flexibility to select multiple values, like either they can see profit or Sales or Both. 

I was trying using parameter action but somehow it is not working. Can someone please help me achieving this. 

 Attaching the .twbx file for the quick reference.     

 

 

 

 

#Tableau Desktop & Web Authoring

7 answers
  1. Divya Chauhan (Kcloud Technologies) Forum Ambassador
    May 15, 6:15 AM
0/9000

Hi Tableau Expert, I have a use case where I need to control multiple measure values in the single chart. 

So, let's say I want to show category wise sales and profit. Now I want user to have the flexibility to select multiple values, like either they can see profit or Sales or Both. 

I was trying using parameter action but somehow it is not working. Can someone please help me achieving this. 

 Attaching the .twbx file for the quick reference.     

 

#Parameters  #Tableau Desktop & Web Authoring

1 answer
0/9000