Forum

Hi Adele, I think when you're a beginner with Power Pivot you should try to follow some simple rules: Dim tables are the 'one' side of the relat...

Hi, It sounds like your final query is included in the append? Mynda

Hi James, If you use Slicers you can use 2 PivotTables; one for the selected driver and one for the total average and plot your chart from a combin...

Hi James, Is there a reason why you're still using combo boxes and not Slicers to do the filtering? Mynda

Yes, that's what I meant. You'd just provide them with a link to the page on your intranet site that already has the Power BI dashboard embedded. M...

Hi Adele, The dotted line indicates an inactive relationship. You can only have one active relationship between two tables. Even though you appear ...

Hi Frans, If you're multiplying the budget amount by 1.05 then you won't get the same result because the 'next year budget' measure is based on the...

Hi Darshan, Thanks for sharing, but this question is about rounding in Power Query using M functions. Those are Excel round functions. Mynda

Hi Adele, That's correct. I would think that you can publish to an internal intranet site that is accessible only to employees and this is no diffe...

Hi Lucy, That consolidate tool you're referring to is for data that's of the same type and in the same format on multiple sheets. e.g. multiple she...

Hi Robin, Great to hear you're making use of Power Query! Without an example file it's difficult to say, but it sounds like your data isn't in a...

Hi Lucy, Just to clarify; all versions of Excel have PivotTables, but not all have Power Pivot. Power Pivot is a different tool that allows you to ...

Hi Irfan, If you go with Sunny's solution (which is nice), be careful to test on all users PC's because you may find the alignment doesn't always r...

Hi Frans, Glad you found what you were looking for. You're right, the helper column is the way to go if you want the filter to contain first and la...

Hi Irfan, You can use a stacked 100% bar chart and add labels for the values. See example file attached. You can't get the labels outside the en...