Forum

Hi Amaro, It's difficult to help without seeing your file. However, the most important thing is that your data is stored in a tabular layout. If yo...

Hi Christoph, The file will only refresh when it's open. In which case you might be best to set it to refresh upon opening. Mynda

Hi Vivian, Create a dimension table that maps the clients to their respective groups e.g. Client Group A A B B C ...

Hi Valerie, I know I cover this in the Power Pivot course in the CUBE functions lessons for Excel. In Power BI a Slicer is just another filter, so ...

Hi Jim, Yes, the course is enough to do what you want. I have copied you on an email to another consultant. Be aware they charge more than the prev...

Hi Michelle, Are you able to share your file so I can see the data structure. Please also give me an example of the calculation you want to perform...

Hi Dave, If you prefer to do this in Power Query then you can split the date into month and year columns, then join them back together in a custom ...

Hi Joachim, Alan and I had the same idea. My PivotTable also has subtotals. Mynda

Hi Julie, It sounds like you're selecting multiple cells containing the dates before you right-click. You only need to select one date cell, then r...

Hi Joachim, If your data is in a tabular layout then you can use a PivotTable to easily summarise the data, but based on the layout above, I suspec...

Hi Lynnette, You'd have to write some VBA to do this, although I'm not even sure VBA could detect if the text is not fitting in a cell in order to ...

Hi Belinda, Please see this tutorial on switching measures based on slicer selection. Mynda

Hi Jim, You need to use Power Query to get the data from Excel and bring it into Power BI. You also need to learn Row Level Security and publishing...

Great to hear you figured it out, Marti!

Fair enough, Erwin. You know your data better than me. I honestly don't understand what the data represents!