Forum

If you're using regular charts, i.e. not Pivot Charts, you can use this Max trick to set the chart labels at specific heights.

Hi Nazaar, Welcome to our forum! Thanks for sharing the link. Unfortunately, the data on that page is not in a format Power Query in Excel or Power...

You could try increasing the gap width and reducing the font size. It looks like the labels might also be bold, if so I'd remove that too.

Hi Richard, I would use a third layout that is similar to your second table, except the KPIs are split into their own columns. i.e. you'd have the ...

Hi PB, With your data unpivoted you're not really creating a PivotTable, which is why you can make changes to any category (because each one is it'...

Hi PB, That can't be done, sorry. PivotTables don't work that way. They are designed to apply the same calculation to all items in a field. You can...

Hi PB, There is a function for NaN values which you can use in a custom column: = if Number.IsNaN([A]/([A]+)) then null else [A]/([A]+) Mynda

Hi Alexandra, Welcome to our forum! Yes, you can use that technique for your data. Just replace the files in the folder with the files containing t...

You can use this formula: =VALUE(MID(B3,2,LEN(B3)-2)) Mynda

Hi Grace, The date format is easy, just format it with a custom number format dd-mmm-yy. The Number column is more complicated. There is a non p...

Hi Tina, There's no standard for ODBC connections as it depends on the source, but I'd expect that users will need to edit the credentials in order...

Glad I could help, CJ. Please see this tutorial on how to write formulas for conditional formatting. Mynda

Hi Maurizio, Catalin wasn't saying you weren't welcome, simply that we know who you are so you can skip the introduction. Mynda

Hi Arte, I don't get it either. I have no idea where the numbers 10046 and 46 comes from in your example file. Please provide a more comprehensive ...

Hi PB, I'm not sure why you would go to all this hassle with formulas when you can use a PivotTable after using Power Query to unpivot your data. I...