Forum

Glad you got it figured out, Philippe. Great to see you're practicing. It's small mistakes like this that solidify our learning. Mynda

Hi Lucy, Thanks for confirming the version of Excel you have. Unfortunately Home and Business doesn't have Power Pivot, but it does have Power Quer...

Hi Philippe, Did you copy and Paste Special > Values, or Copy and Paste? If that's not the problem are you able to share the exact steps you're ...

Hi James, Thanks for sharing a sample file.This makes it a lot easier for us to help you. I'd use a PivotTable and Slicers for this, assuming yo...

Hi Paul, You were almost there. The 'Site 5 Data' series had labels applied, you just need to turn these off because you want the labels on the 'Si...

Hi Charles, If you want users to toggle easily between filters then I'd use Slicers in a PivotTable. The idea with Power Query is to limit the data...

Hi Lucy, Thanks for sharing your file. Please tell me what version of Excel you have and is it Professional Plus, Home & Student etc. I need...

Hi Lucy, No file attached. Please click the 'Start Upload' button to complete the upload of your file. Also, what version of Excel do you have a...

Hi Lucy, It's very difficult to visualize your complex scenario without a sample Excel file. That said, you could (maybe) use Power Pivot to create...

Hi Linda, This post explains which versions of Excel support Power Pivot: You'll see for Excel 2013 it's Office 2013 Professional Plus or Exce...

Hi Aleksandrs, Try using Text to Columns but in step 3 of the wizard change the destination to $B$1. I'm wondering if column A is formatted as text...

Yep, that's what I'd do too.

Hi Pablo, Can you please share a screenshot and also provide information on where you saved this dashboard from? Did you publish a Power BI Desktop...

Hi Benedikte, It's a bit difficult to visualise, bit presumably the blank is in the table that the Slicer is connected to, so I'd go to that table ...

Hi Jose, Thanks for sharing a sample file. In the attached I've inserted the rows for you. Please inspect the 'Applied Steps' to see how it was don...