Forum

Mynda Treacy
@mynda
Admin
Member
Joined: Jul 16, 2010
Last seen: May 18, 2025
Topics: 0 / Replies: 4762
Reply
RE: Keep rows but remove duplicates in a column

Hi David, It looks like Riny has answered your question. Please advise if not as I've lost track! Mynda

3 years ago
Forum
Reply
RE: Issue with slicer for data model

Hi Jennifer, The issue you're having is caused by the direction of the relationships in your model. If you look at the arrows on the connector line...

3 years ago
Forum
Reply
RE: Keep rows but remove duplicates in a column

Hi David, It's not clear if you want a staff count by day, or whether the day data is irrelevant. If the date is irrelevant, then like Adam suggest...

3 years ago
Forum
Reply
RE: Look Up Charts

Hi Matt, I would only use that approach if you wanted different chart types or different formatting for each chart. Otherwise, Slicers and Pivot Ch...

3 years ago
Reply
RE: Line Chart showing up as dots and not lines

Hi David, If you read the file called 'Read me first' that was included in the Zip file you downloaded from our site, you'll find the answer to the...

3 years ago
Reply
RE: Bubble chart data not fully appear

Hard to tell from the screenshot as I can't even see the outer edge of the chart. At a guess I'd say the plot area is too small.

3 years ago
Reply
RE: Create General Ledger (Urgent Required)

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. ...

3 years ago
Reply
RE: Adding new columns in source data for Power Bi

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

3 years ago
Reply
RE: Pivot Tables - Grand Totals AND Summary Percentages in the same table?

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...

3 years ago
Reply
RE: Excluding or including a list on pivot filter

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

3 years ago
Reply
RE: Pivot Table - Preserving Wrap Text on Refresh

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...

3 years ago
Reply
RE: Combine and Unique Query Results

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...

3 years ago
Forum
Reply
RE: Sharing options for a dashboard

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

3 years ago
Forum
Reply
RE: Power Query/Power Pivot vs. Power BI.

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...

3 years ago
Forum
Reply
RE: Sharing options for a dashboard

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...

3 years ago
Forum
Page 46 / 318