Forum

Mynda Treacy
@mynda
Admin
Member
Joined: Jul 16, 2010
Last seen: Jun 25, 2026
Topics: 0 / Replies: 4786
Reply
RE: Power Query not exist join

Hi RH, Welcome to our forum. Can you please upload an Excel file containing your examples to save us having to manually enter it into a worksheet i...

7 years ago
Forum
Reply
RE: Select a random sample

Hi Linda, You can use the List.Random function for this. Mynda

7 years ago
Forum
Reply
RE: Bar chart formatting

Hi Marcus, Sorry, I thought you were asking how you could overlay one series on top of the other series as shown in your Tableau charts. The Y ...

7 years ago
Forum
Reply
RE: Unable to make columns in a Clustered Column Chart wider

Hi Mark, I wasn't aware that you had more than 2 teams. In that case I'd recommend small multiples style of chart because the stacking makes it dif...

7 years ago
Forum
Reply
RE: Controlling Refreshes in Multi Level PQ

Hi Ken, One option is to leave the first 3 queries in one workbook and in a new workbook write a new query that gets the data. Alternatively, t...

7 years ago
Forum
Reply
RE: Duplicate Entries get generated after merging

Hi Santosh, Can you please share your file? Mynda

7 years ago
Forum
Reply
RE: How to rearrange cell values in same row over different columns

Hi Laurens, Please see file attached. Note: Networks was in two groups and the source data had USGov which wasn't in the tag list so I changed it t...

7 years ago
Forum
Reply
RE: Bar chart formatting

Hi Marcus, Thanks for sharing the images. I'm not aware of any way to change the width and overlap for a single series in the formatting options. T...

7 years ago
Forum
Reply
RE: Unable to make columns in a Clustered Column Chart wider

Hi Mark, You can try changing the X axis settings for category width and inner padding to make the columns wider. That said, I would make this a...

7 years ago
Forum
Reply
RE: Bar chart formatting

Hi Marcus, No images attached. That said, I don't think you can change the width of bars for a series. Mynda

7 years ago
Forum
Reply
RE: How to rearrange cell values in same row over different columns

Hi Laurens, Please upload a sample Excel file that shows a few scenarios and the desired results so we can help you further. Thanks, Mynda

7 years ago
Forum
Reply
RE: Meeting issue at Relationships 6.02

Hi Chen, No idea why your Table was created for all rows as opposed to just the occupied cells. Maybe you accidentally edited the range before inse...

7 years ago
Forum
Reply
RE: Meeting issue at Relationships 6.02

Hi Chen, I looked at the file you sent via email and I can see the problem is that the Excel Table on the 'Dates' sheet in the file extends to the ...

7 years ago
Forum
Reply
RE: Calculating # customers / # orders in banding table

This measure is summing the number of customer types, not the number of distinct customers: # Customers by Banding = SUMX(Customer,IF([Selected ...

7 years ago
Forum
Reply
RE: Meeting issue at Relationships 6.02

Hi Chen, To delete a relationship just click on the connector line in the diagram view and press the Delete key. Mynda

7 years ago
Forum
Page 237 / 320
0