Skip to main content

#Tableau Desktop & Web Authoring185 utenti parlano di questo argomento

Avishek Dey ha fatto una domanda in #Tableau Community Updates

I have this use case where I need to have an Apply All Filters button in all of my dashboards within a single workbook. The ask is if i select something on Dsb1 and click Apply All Filters, it should filter both Dsb 1 and Dsb 2. Also, if I go and do some new/change selection in dsb 2 and click on Apply All Filters, it should filter both Dsb 2 and Dsb 1. 

I can achieve one way Dsb 1->2...but when I applying the reverse it is weirdly navigating to the next dsb. Attaching a wbk, if anyone can solve this for me. 

2 risposte
  1. Ieri, 06:41

     Try using filter actions instead of navigation actions. Make sure both dashboards share the same filter fields and check the button action settings to avoid triggering dashboard navigation. 

0/9000

This pop-up appears when I select one or more cells from a dimension in a table. I would like it to show just the AVG, rather than the SUM of AVG, which is mathematically misleading.Can I modify the aggregation displayed in the mark selection summary pop-up in Tableau?I have tried:

  • Setting the measure’s default property aggregation to average
  • Using a calculation (i.e. AVG([field])) with the default property total set to average
  • From the Analysis menu, setting Total All Using to average

Thanks. 

 

 

#Tableau Desktop & Web Authoring

2 risposte
  1. Ieri, 13:35

    The tooltip displayed is known as an 'uber' tooltip and is not modifiable by design.  If you do a search on the Ideas Exchange for 'uber' you can upvote the existing idea there to allow for modification of it, and as most people desire, the removal of it in some cases. 

     

    If this response answered your question, please mark it as an Accepted Answer? 

    This way, others searching for similar solutions will find the answer faster in the future.

     

    Best, Don Wise (Tableau Ambassador)

0/9000

Hi,

 

I am trying to apply filter to a worksheet in dashboard so that the worksheet is visible only when we select the filter. When the filter is "ALL", i want to hide the worksheet. I am not sure if this is possible or not.

 

I have Dimensions "category" and "subcategory" as filter. On the dashboard, I want a view where category bar chart is visible and hide the subcategory bar chart. and Sub-category is visible only after we select "category" filter.

 

So, in my initial view I want this part hidden.

View Worksheet on a Dashboard only after a filter is selected

2 risposte
  1. Ieri, 11:54

    I understand this topic might have already been resolved, but as part of my own learning and practice, I would love to share a solution that worked perfectly for me. I hope this adds value to the thread! 

     

    Yes, this is absolutely possible using Tableau’s standard features! You can achieve this dynamic layout where the Category chart automatically stretches to 100% width and then shrinks to make room for the Sub-category chart.

    The secret lies in combining a Horizontal Container, a Dashboard Filter Action, and carefully managing the container properties (specifically, unpinning the fixed widths).

    Here is the complete step-by-step guide to setting this up:

    Step 1: Build the Dashboard Layout

    1. Create a new Dashboard.
    2. From the Objects pane on the left, drag and drop a Horizontal Container onto the dashboard.
    3. Drag your Category chart into this container.
    4. Drag your Sub-category chart and drop it inside the same Horizontal Container, right next to the Category chart.
    5. Crucial Step 1: Right-click the title of the Sub-category chart and select Hide Title. (If the title remains visible, the worksheet will not shrink completely to 0 pixels).
    6. Crucial Step 2: Click on your Category chart on the dashboard, click its drop-down menu (the small inverted triangle), and make sure Fix Width is NOT checked (unpinned). Do the exact same for the Sub-category chart. This allows both sheets to resize dynamically based on data availability.

    Step 2: Configure the Dashboard Action

    1. Go to the top menu and select Dashboard > Actions...
    2. Click Add Action > Filter...
    3. Configure the settings as follows:
      • Source Sheets: Check only your Category chart.
      • Run action on: Select Select (Click).
      • Target Sheets: Check only your Sub-category chart.
      • Clearing the selection will: Select Exclude all values (This is the rule that completely empties the sheet when unselected).
      • Target Fields: Select All Fields.
    4. Click OK.

    Pro-Tip for Perfect Layout:

    If you want both charts to take up exactly 50% and 50% of the space when a category is selected, select the Horizontal Container itself (the outer blue frame), click its drop-down menu, and select Distribute Contents Evenly.

    How it works:

    • Initial/Default View: Since no specific category is clicked, the Sub-category chart has 0 rows of data. Because the title is hidden and "Fix Width" is unchecked, its width drops to 0 pixels. This forces the Category chart to automatically expand to fill 100% of the container.
    • When Clicked: The Sub-category chart populates with bars and naturally takes up its fair share of the container, causing the Category chart to gently shrink and sit beautifully side-by-side with it.

    Hope this helps, and I'd love to hear if this approach works for your future dashboard designs as well! 

     

    Best regards, 

    Keisuke TASAKA / DATA Saber Apprentice

0/9000

Hi Team,

Requirement 1:

 

When the dashboard is opened, it should display

Category-wise Sales for only the following two categories by default:

  • Furniture
  • Office Supplies

Requirement 2:

 

When the user selects the tick box (checkbox), the dashboard should switch to display

Category-wise Profit for the following three categories:

  • Furniture
  • Office Supplies
  • Technology

Note: The above requirement can be achieved using a parameter; however, the business requirement is to use a tick box (checkbox)

instead of a parameter. 

 

I have attached the Tableau workbook for reference. 

Regards, 

Venkat 

 

#Tableau Desktop & Web Authoring  #Tableau Server  #Tableau Cloud  #Tableau Public  #Tableau  #Tableau Next  #Tableau Community Updates  #Tableau Pulse  #Tableau Mobile  #Tableau Agent

1 risposta
  1. Ieri, 11:05

    Hi, 

    Are you looking for something like the attachment? Please take a look. 

     

    The idea is to create parameters with ON/OFF values and then set up corresponding fields that switch OFF/ON in response, allowing you to control visibility through parameter actions. A dedicated sheet is prepared for the checkbox, where ON and OFF are represented using shapes. Please see the details below. 

      

    This was implemented using only standard features. The display switching is handled by configuring a DZV. 

     

    <sample>Hi, Are you looking for something like the attachment? Please take a look.image.png

     

     <parameter>image.png

     

    <calc>image.pngimage.pngimage.png

     

    <dashboard action>image.png

     

     <check box sheet settings> 

    Using the ā€œoff‑onā€ field from the checkbox sheet, the display switching is achieved through a parameter action. 

     

    -Configuration for the checked state. Please pay attention to the shape and color.

     

    *Sorry if the square shape is a bit confusing, but the checkbox frame itself is represented using borders.ā€

    image.png

     

    -Configuration for the unchecked state. Please pay attention to the shape and color.

    image.png

     

    <Dashboard DZV settings>image.png

0/9000

Unable to complete action 

Authentication failed. 

Error Code: 84223ADA 

Tableau received an OAuth error from your request.  Please see the error message for more information: 400 Bad Request 

POST

https://oauth2.googleapis.com/token

 

  "error": "invalid_request", 

  "error_description": "Could not determine client ID from request." 

}. 

 

#Tableau Desktop & Web Authoring

1 risposta
0/9000

 Hi, 

Could you please give me a

hint

on how to center (if possible) all values in the table? 

I want to

align them all vertically. Right now it depends on

the width of the numbers. 

I know it's not strictly a table as it's continuous, but it must stay as is  

 

#Tableau Desktop & Web Authoring  #Trailhead  #Salesforce

1 risposta
0/9000
Venkat M ha fatto una domanda in #Tableau Agent

Hi Team, 

Requirement: Display data dynamically based on the selected Period Type parameter

  • Day
    • When the user selects Day in the Period Type parameter, the Order Date parameter should display all available dates.
    • The most recent available date should be selected by default.
  • Week
    • When the user selects Week, the Order Date parameter should display only the Monday date of each available week (e.g., 27-Jul-2026, 20-Jul-2026, 13-Jul-2026).
    • Upon selecting a week, the report should display data for the entire Monday-to-Sunday period corresponding to that week.
  • Month
    • When the user selects Month, the Order Date parameter should display all available months.
    • The latest available month (e.g., Jul-2026) should be selected by default.
  • Quarter
    • When the user selects Quarter, the Order Date parameter should display all available quarters.
    • The latest available quarter (e.g., 2026-Q3) should be selected by default.
  • Custom Dates
    • When the user selects Custom Dates, the following parameters should be displayed: 
      • Start Date
      • End Date
    • Report data should be filtered based on the chosen date range.
  • Lifetime
    • When the user selects Lifetime, all available data should be displayed without applying any date filters.
  • #Tableau Agent

#Tableau Desktop & Web Authoring  #Tableau Server  #Tableau Cloud  #Tableau Public  #Tableau  #Tableau Prep  #Tableau Community Updates

5 risposte
0/9000

Hi 

I need some help. Does anyone have any idea how I can go about this error.   

It's not allowing me to open the sheet that was send over.

 

#Tableau Desktop & Web Authoring

0/9000

As shown in the attached twbx file, when running on the Tableau Desktop WIN version, the hover display appears blank. However, it functions normally after publishing to Public. The issue persists on the Windows desktop version, and potential causes such as antivirus or encryption software have been ruled out. A thorough resolution is required. 

 

#Tableau Desktop & Web Authoring

2 risposte
0/9000

As shown in the attached twbx file, when running on the Tableau Desktop WIN version, the hover display appears blank. However, it functions normally after publishing to Public. The issue persists on the Windows desktop version, and potential causes such as antivirus or encryption software have been ruled out. A thorough resolution is required. 

 

#Tableau Desktop & Web Authoring

0/9000