Forum

Hi Martin, Thanks for clarifying. When you reference a measure in a formula you don't have to explicitly reference it. That is to say you don't ...

Hi Martin, Thanks for using the forum to post your question. I've moved it to the Power Pivot course members group. Please use this for questions r...

Hi Teri, Thanks for using the forum to post your question. I've moved it to the Course Members Power Query forum. Please use this forum for course ...

Hi Jesus, I wrote about using text labels in Y axis here. Let me know if you have trouble applying it to your chart. Mynda

Hi Melyved, I suspect your errors are a result of values in those columns which are not whole numbers. They might be text or something else that ca...

Hi Olivier, Dynamic Data Validation isn't something built into Excel, and so getting it to work is done with a clever use of named ranges. As a res...

Oops, sorry I forgot to press 'Start Upload'. Here it is.

Hi Olivier, There are two ways to achieve dependent data validation lists: 1. The easy way (similar/same as Contextures): 2. The more complex ...

Hi Joepy, The nice thing about an in-cell bar chart or data bars is that you can easily align them to cells containing other information relevant t...

It sounds like you're using the technique for importing CSV or Text files from a folder. The technique for importing Excel files is different. For ...

Thanks for sharing a sample of your data. I don't recommend any formulas for this. The data really should be cleaned, then you can use PivotTables to ...

If you've 'Closed & Loaded' that query to a table in the workbook then any user should be able to see the data. If they get the error/warning they...

No, sorry. PivotTables only display data from the data source they are linked to. The best you could do is add a column beside the PivotTable but you ...

Good idea, Catalin. That reminds me of a post I did to show rolling 12 month periods: Mynda

Hi Divisha, This is by design in Excel. Excel uses double precision floating-point format which can only hold 15 digits of precision. The solution ...