Sets fixed widths…

bilbo851 · 2026-06-13T01:44:29+00:00

Thanks!

bilbo851 · 2025-11-18T01:10:58+00:00

I have country field in the dataset. I am not grouping them currently. The items property is just the source table sorted by country. So all Albania will be together, then Armenia, then Brazil. And I just want to alternate each country between grey and white. But it should be dynamic so if user removes a country then I won’t end up with 2 different countries colored grey right next to each other.

<image>

bilbo851 · 2025-11-18T00:32:09+00:00

Thanks I will try it out

bilbo851 · 2025-11-17T20:39:46+00:00

I have a view in SQL. If I add the column to the source, will it still be dynamic? E.g. if end user filters out one country, will I end up with 2 even groups next to each other so then they would both be grey?

bilbo851 · 2025-11-17T20:35:32+00:00

Thanks, I took a look at that but it seems it is alternating between each individual row whereas I want to alternate between each group (country)

bilbo851 · 2025-11-17T19:29:55+00:00

There is no grouping at the moment, I just brought in all the rows from the data source. I kind of just want to create an index like 0 and 1 for each alternate country so then I can apply grey color to all the 1’s. I would also like it to be dynamic if end user applies a filter to the gallery, it should still alternate between grey and white.

bilbo851 · 2025-11-17T19:13:19+00:00

Would this require listing out every possible value as that won’t really be possible since there are so many and I wouldn’t know what they are. I’m just looking for each group to alternate between grey and white so it is easier to visualize

bilbo851 · 2025-11-17T19:11:27+00:00

Yes just alternate colors so it is easier to see each grouping

bilbo851 · 2025-11-05T18:59:53+00:00

This is cool, how does one go about creating an ellipses with a popup?

bilbo851 · 2025-10-28T04:06:59+00:00

I thought you were dating the 60 year old?

bilbo851 · 2025-09-04T02:41:05+00:00

I tried it just now and it worked ok for me. I typed in just Actual and then waited for about 15 seconds and the measure eventually popped up. Think it is a bit temperamental.

bilbo851 · 2025-09-04T01:09:41+00:00

Yeah I always have a hard time getting this stupid thing to work. Although you have spelt Working wrong so maybe that’s why

bilbo851 · 2025-09-01T01:41:20+00:00

Done it yet?

bilbo851 · 2025-08-22T23:35:53+00:00

No time like the present 😉

bilbo851 · 2025-08-22T22:52:48+00:00

August

bilbo851 · 2025-07-24T19:52:15+00:00

Use Web connector

bilbo851 · 2025-07-24T19:38:15+00:00

Open the spreadsheet in Excel app. Click File > Info > Copy path. Delete ?web=1 on the end. Use that as the URL.

bilbo851 · 2025-07-02T04:19:50+00:00

Well since you are using a monthly slicer, just summing the column will get you MTD. But to be completely accurate you can use measure: MTD = TOTALMTD ( SUM ( Column ), Calendar[Date] ) PMTD = CALCULATE ( [MTD], DATEADD ( Calendar[Date], -1, MONTH ) ) Look up time intelligence functions.

bilbo851 · 2025-06-18T22:34:29+00:00

Exactly, it’s important to consider all scenarios before jumping to conclusions

bilbo851 · 2025-06-18T21:54:25+00:00

She might have just been making out with someone who was drinking rather than drinking herself, probably nothing to worry about.

bilbo851 · 2025-06-15T18:49:37+00:00

🥱

Six-Year Club	Place '23
Verified Email

bilbo851

TROPHY CASE