Forum

Robert Green
@robbieg
Trusted Member
Joined: Nov 9, 2020
Last seen: Mar 6, 2025
Topics: 14 / Replies: 25
Reply
RE: Excel Sort within a cell

Thank you for the followup, Alan.

2 months ago
Reply
RE: Excel Sort within a cell

@alansidman Thank you Alan. And thank you for showing me Modulo for creating an 'index' for pivoting on. I will be able to use that again. A follo...

2 months ago
Topic
Replies: 5
Views: 306
Reply
RE: Splitting a cell contents into separate columns based on column header

Thank you, Riny. Perfect! And by adding an Index column at the beginning and then removing it at the end, I can keep the original order. Many...

9 months ago
Reply
RE: Show items with no data in a Power BI chart

It seemed to be working for column charts but not for bar charts Doh! I was looking at the wrong axis. Yes - it does work. I hadn't noticed that...

11 months ago
Topic
Replies: 3
Views: 493
Reply
RE: Trying to hide a table when no slicer is selected

Brilliant logic! Thank you, again, Riny. Best wishes

12 months ago
Reply
RE: Trying to hide a table when no slicer is selected

Thank you for looking again, Riny Yes, (I think) I've tried that also, but I don't want to show all the services in the table. I need to wait until...

12 months ago
Reply
RE: Trying to hide a table when no slicer is selected

Thank you, Riny. Yes - that works, but it's the services that I am wanting to show in the table rather than the categories!

12 months ago
Reply
RE: Transpose multiple columns into multiple rows

Gotcha. Thank you again. Really great. Cheers R

1 year ago
Reply
RE: Transpose multiple columns into multiple rows

Thank you, again, Riny. I started off by unpivoting but I got stuck with the result I got. There is some M language in there that I am not famil...

1 year ago
Reply
RE: Filled Map gradient

Thank you, Mynda. I'll give that a go. Sounds like a plan! Yes - Shape Maps are a pain - unless you live in the US where there are loads. Here in G...

2 years ago
Page 1 / 3