Forum

Hi Kathie, It depends...if the text in your column doesn't have any spaces you want to keep then you can choose the 'Space' delimiter and it will r...

Hi Juan, Indeed there are many hidden sheets in this file. They are hidden in the Visual Basic editor. If you go to the Developer tab > Visual B...

Hi Mark, If you only want a dozen or so codes then you'd do this filtering out in Power Query instead of bringing all of the data into your Power P...

Hi Mark, Thanks for clarifying. In the real world those 1M+ department codes would be grouped into a hierarchy and you would filter at an upper ...

Oh, yes that'd be the problem. The Slicer must be connected to a PivotTable, not a regular Table.

Hi Mark, Are you talking about filtering in Power BI or in Excel? I ask because this question is in the Power BI forum, but you mention 'Advanced F...

Hi Chris, #N/A is returned if the set_expression syntax is incorrect. Has the PivotTable that the Slicer is connected to been deleted by any chance...

Great! So glad it was a simple change.

Hi Graham, I'm not sure why the Excel functions differ from their Power Query equivalents, but it's probably because they wrote the Power Query for...

Hi Matthew, I'd say that is a limitation of using filters on a Table that is the source for a chart. Are you able to provide a sample file that we ...

That's normal for Excel when you open CSV or Text files that have a different locale to the language settings of Excel. When you change the data ty...

Hi Kirk, I'm not aware of any way to detect errors in Power Query that don't prevent the query loading. i.e. you can have row level errors that sim...

Hi Wen, You have these problems because the source data is not in a format that supports the formulas. The first rule of Excel is to put your data ...

Hi Juan, The horizontal axis reference must contain more cells than the reference to the series data. If you right-click the chart in Excel > Se...

Hi Safirah, This post explains how to convert dates into fiscal periods. And this post shows you how group dates into fiscal years for Slicers, but...