Forum

Hi Reehan, You also asked this question in our Help Desk, to which I replied. Please only ask your question in one place to save everyone time. ...

Open the query editor in Power BI (Home tab > Transform Data). Then on the Home tab > Advanced Editor.

Hi Max, I know it seems simple, but that's not how PivotTables are designed. They can't distinguish between showing the breakdown for some calculat...

Hi Stelian, Welcome to our forum! You could use CUBE functions to extract just the data you want. Mynda

Hi Alicia, If the settings you've already selected aren't working then I'd say you can't. I'm not aware of any other setting you could apply that w...

Hi Shawn, Welcome to our forum! Please see this post on merging lists in Power Query. If you're still stuck, please create a small Excel exa...

Hi Bruno, I'm not sure, sorry. You'd have to speak to your SharePoint administrator. They may have prevented sharing. Mynda

Hi Zeref, Welcome to our forum! Power Query and Power Pivot skills will definitely be well worth learning as a BI Analyst. These tools are integ...

Hi Bruno, Or you can securely embed the dashboard in a web page. This is free for everyone, whereas Power BI requires all users to have a licence a...

Hi and welcome to our forum! The IF, SUMIFS etc. are what's making your file slow. You're better off using Power Query to get your source data in o...

How about using FILTER: =MIN(FILTER(DataTable[Retail_Price],(DataTable[Product]=[@ProductResult])*(DataTable[Colour]=[@ColourResult])*(DataTable[We...

Hi Pierre-Stephane, I'm not sure why it wouldn't be displaying the correct columns. Can you please send a screenshot of what you see in the Custom ...

Hi Khunsu, Welcome to our forum! Please see my introduction to Power Query video where I demonstrate a few uses for it. Hope that gives you some in...

Hi Luca, Yes, you can use 'Show Values As' to calculate the difference. Let me know if you get stuck after reviewing the tutorial linked to. Myn...

Hi Zaki, Select the timeline slicer > CTRL+1 to open the formatting > Properties > deselect 'locked'. Go to Review tab of ribbon > Prot...