Forum

Velouria
@debaser
Moderator
Member
Joined: Nov 1, 2018
Last seen: May 22, 2025
Topics: 0 / Replies: 838
Reply
RE: Pivot table chart issues - dates on x-axis and adding another series

Which version (and build, if 365) of Office do you have?

1 year ago
Reply
RE: reporting in Excel

Right-click the link and choose Save Link As... instead of just clicking on the link normally.

1 year ago
Reply
RE: Default item from a dropdown list, when selecting a Slicer?

FWIW, if you don't want the additional column, you can amend the FILTER formula to do the same work: =FILTER(Source[Name Product],BYROW(Source[Cate...

1 year ago
Reply
RE: TEXT JOIN

For 2019 I think you can just remove the FILTER function from Riny's formula and replace it with IF: =TEXTJOIN("/",,IF(Table1[item Code]=B4,Ta...

1 year ago
Reply
RE: Error Message When Refresh Query & Source Files Open

What is your connection? I have several reports that run off files in sharepoint that are open (usually in Teams) most of the time, and have never had...

1 year ago
Forum
Reply
RE: Rank Multiple Columns at Once

I don't think so. You can add one rank column that ranks on both of those columns, but not two separate ranking columns in one operation.

1 year ago
Forum
Reply
RE: reporting in Excel

If you just want it to look like that, then yes, certainly.

1 year ago
Reply
RE: Adding Table from Columns

The data in that field is not a List

1 year ago
Forum
Reply
RE: Adding Table from Columns

If you click to the right of one of the Error values, what does it show you for the error?

1 year ago
Forum
Reply
RE: Range or Table and Formulas in a Pivot Table?

I'd definitely use a table. What's the original data source? Can you use Power Query to get the data from it directly into the table, rather than copy...

1 year ago
Reply
RE: Power Query - Multiple Users Conundrum

I'm not aware of any way to force users into their own sheet views. I don't really follow your question about Lists - can you elaborate? My th...

1 year ago
Forum
Reply
RE: Power Query - Multiple Users Conundrum

Power Query is part of Power BI, so you can do all the same data manipulation, before getting into the presentation aspects.

1 year ago
Forum
Reply
RE: Power Query - Multiple Users Conundrum

Yes, you can set up slicers and filters and what one user does will not affect what another user sees.

1 year ago
Forum
Reply
RE: Power Query - Multiple Users Conundrum

I know you can read/write data in Sharepoint lists using ADO, but I'm not sure if that will work to an Excel file data source on SP/OD. If I find some...

1 year ago
Forum
Reply
RE: Power Query - Multiple Users Conundrum

It would depend somewhat on the circumstances. I was thinking ADO, though I'm not sure how well that will work with Sharepoint as a back-end file loca...

1 year ago
Forum
Page 6 / 56