Forum

Hi Tom, I've got some ideas for this. Can you please upload a sample Excel file so I can give you an example in response. Mynda

My pleasure, Carolyn. Best wishes to you too for Christmas and 2018! Mynda

Hi Carolyn, How about a compromise where you show the total YTD irrespective of the Slicer selection and then you also show the values for each yea...

Hi Matthias, You raise a good point and if you're the only one using the Excel workbook then you should use whatever is more efficient for you. How...

Hi Rosemary, Are you thinking the table isn't linked because it doesn't show the link icon in the table tab in Power Pivot in Excel 2016? If so, do...

Hi Cele, Power Query only sends data to the file containing the query. You can't send it to an external file. i.e. Workbook 2. AFAIK you can hid...

Hi Carolyn, You need to write a DAX measure that calculates the prior period values in context of the period selected in the Slicer. See Power P...

Hi Carlos, You need to write a DAX measure using the time intelligence function PARALLELPERIOD. It doesn't look like you did the Power Pivot course...

Hi Mitul, Clark's formula is an excellent demonstration of Excel's flexibility, and his formula writing prowess. However, as I explained to you via...

Hi Bax, Thanks for the heads-up. I've reported it to Microsoft. Looks like they broke their code in an update! Hopefully it will be fixed soon. ...

Hi Rob, At this point in time the number format displayed in the ToolTip comes from the format of the column that is set in the modelling tab. U...

Hi Frans, Make the negative spec values negative. Change it to a bar chart and make the axis label position Low and make the overlap 100%. Mynda

Hi Frans, I'm not sure I'm picturing what you want correctly, but in the attached file I inserted a Pivot Chart based on a rearranged version of yo...

Hi Aslak, I would just use a PivotTable to do this. In the file attached there is the PivotTable solution and the Power Query solution. It's up to ...

Hi Adele, If your member data is at the month level of detail then I would think it's possible, but if you only have member information at a point ...