Last seen: May 21, 2025
Hi James, Welcome to our forum! You would have to use a Power Pivot PivotTable and write a DAX measure to count scores > a certain percentage...
Hi Wim, While the value is in the model, it's not in the model at the level of sales rep, only at the unit level. This means you have to use a work...
Hi Wim, Thanks for sharing your file. I don't see anything wrong with your approach. Not sure why you think there should be a better way. Mynda
Hi Wim, No file attached. Please try again. Be sure to click the 'start upload' button after selecting your file and then wait for the grey check m...
Possibly. However, it's also sometimes helpful to see the key issues in context of the larger dataset (case in point illustrated in the link in my pre...
Hi Jacqui, If you have 365, the sheet is named the same as the query. In earlier versions of Excel this functionality isn't available, so it sounds...
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...