Forum

Hi Justin, Slicers can only control a single table. If you want to control multiple reports, then you can create PivotTables from your Table source...

Hi Tyrell, Welcome to our forum! What other PivotTables are you trying to connect to? Where are they and what are they called? Note: only PivotT...

Hi Shawn, This problem existed in your original file shared on this forum, so I don't think it's related to any recent changes to names. It also is...

Hi Justine, Please upload your sample file. You need to click the 'Start Upload' button after selecting your file and then wait for the grey check ...

It can't be done in the PivotTable, sorry.

Hi Kenneth, If you have Microsoft 365 you can use this formula: =TEXTJOIN(", ",TRUE,FILTER(A4:A10,(ISNUMBER(SEARCH(B1,B4:B10))+ISNUMBER(SEARCH(B...

Hi Dieneba, Welcome to our forum! The Insert Data From picture feature is only available with 365 for Mac, Excel for iPhone and Excel for Androi...

"Bar charts only have nested axis labels for Pivot Charts or regular bar charts with more than one row of axis labels." In other words, you have a reg...

You need to do this in the Power BI model. Ideally this should be done in Power Query where you set the data types.

Hi Velouria, Not sure why you see something different. When I edit the chart references I see the axis labels are pointing to: ='New-Metrics-Wor...

Hi Mark, Welcome to our forum. PivotTables aren't designed to work that way. If you collapse the year it will show you the year total as you've fou...

Hi Yuan, That's an interesting problem. I can't see what's causing it, sorry. Mynda

Hi Shawn, 1. The formulas for your named ranges are correct, although you don't need the IF(COUNTA(... A more efficient way to write it is using IF...

Hi PA and welcome to our forum! Have you tried using Slicers or Timeline Slicers to allow the user to select different levels: days, months, quarte...

Hi and welcome to our forum. I wouldn't classify Power Query as a watered down VBA tool. It's a dedicated ETL (Extract, Transform and Load data) to...