Forum

Hi Karen, Correct, you should use the Slicer from the dim table, but you should also use the division field from the dim table in the PivotTable, n...

Hi Kelly, Welcome to our forum! I think labeling 4000 data points is probably not very useful. I recommend selecting the points you want highlig...

Hi Graham, Welcome to our forum! Each series' data labels are independently formatted, so there's no default way to ensure the series name is al...

I tested it on my PC. When you follow the steps in that video, one of the columns contains the file path. This file path contains the folder name. All...

Hi Bill, Welcome to our forum! Unfortunately, Excel 2013 does not have the newer options to load to PivotTable and Pivot Chart. There's no way t...

Hi David, Welcome to our forum! First, you should always use Power Query to get the data from your SQL database and then load it to Power Pivot/...

Hi Patrick, Please see this tutorial on grouped running totals in Power Query. Hope that points you in the right direction. Mynda

Hi Paul, Using From File > From Folder and after you choose Transform Data normally you would click on the double down arrow on the content colu...

Hi Shelley, There is a similar question here that has been answered in the Microsoft Power BI forum that gives some options for solving this. My...

Hi Garth, Please try uploading the file again. Be sure to click the Start Upload button after selecting your file and then wait for the grey check ...

Thanks for the files. You cannot insert a slicer for a regular chart. Slicers only work with PivotTables and Pivot Charts. In my completed file for le...

Hi MC, Load the table containing the bonus value to Power Query, then drill down to the bonus cell: select the cell > right-click > drill dow...

Hi Bax, You can modify your added column formulas like so: = Table.AddColumn(#"Added Conditional Column7", "PO < " & Text.From(HourBand1)...

Hi LaDonna, Welcome to our forum! Your file didn't attach. Please try uploading again. Be sure to click the 'start upload' button after selecting y...

Hi Rick, There's no specific tutorial on loading JSON files, but there is a JSON connector in the Get Data > From File > From JSON in the Pow...