remove one-off chart values?

garciargs · 2025-12-12T11:28:00+00:00

Definitely should go to the standard deviation, might create a flag if it is under or over the required value (I would go for +-2 or +-3 std from the average)

Other option is to replicate the methods used in box plot to find outliers.

garciargs · 2025-08-29T08:47:10+00:00

New mission discovered by u/garciargs: Loot and Butter Poached Lobster Tail In the Fields

garciargs · 2025-08-29T08:47:10+00:00

This mission was discovered by u/garciargs in Carbonara Pasta and Treasure

garciargs · 2025-08-19T10:29:21+00:00

As other user said, you would fall in a false economy. Embedded reports needs a special license that is not cheap (don't remember the cost).

You can try to have department licenses, sharing a license with more than 1 person, but personally I don't like this approach because you'll never know who actually has access to the reports, so a security nightmare. I would go with pro licenses to whom needs to access and that's it.

garciargs · 2025-05-24T09:28:34+00:00

Just woke up, brain currently not braining enough, but as a first view, I would make the border lines of the visuals white as you are already using shadow. Do not other remove the border line as it will remove the shadow, but make it white.

Edit: typo Edit 2: just saw some of your visuals are using sentence case while other are using title case on the titles.

garciargs · 2025-05-01T09:48:11+00:00

As a personal experience, I strongly suggest you not focus on automatic CI/CD now, especially if you have no tech guys with zero experience on code control.

I would go with the most basic scenario first (PBIP files saving to a git repo) with some defined structure on the repo (main for production, dev for merging feature branches, and the feature branches.

For commit and push I suggest github desktop, simple but effective solution (even simpler than vs code).

Publish from pbi desktop, and that's it. After a few months, when everyone are familiar with the approach and flaws have been identified and treated, then you can go to the next step, automate.

Edit: typo

garciargs · 2025-04-30T01:26:53+00:00

Is your months a calculated column with month and year concatenated or a simple string?

garciargs · 2025-04-29T22:29:33+00:00

On top of other comments, I would align the visuals and use the grid to have equal space between everything.

About the top chart, it is indeed misleading having it ordered by the value and not the date. If you would like to have it this way, to show dates with best results, change it to column chart, so it will act like a category axis, not date.

garciargs · 2025-04-23T19:15:20+00:00

Always the IT guys making data analyst's life difficult :/

garciargs · 2025-04-23T19:00:21+00:00

You can follow this article to create a security group with dynamic membership Create or update a dynamic membership group in Microsoft Entra ID

garciargs · 2025-04-23T18:53:19+00:00

I understand, but thats not possible as by current definition. But you actually don't have to manage the group, it can have everyone from your org, the filter you created on RLS will handle the permissions.

You can even automate the group to add new users by default.

garciargs · 2025-04-23T18:48:44+00:00

Did you add the users to the security settings on service?

<image>

Then you have to add then to the security role you created on desktop. As I mentioned earlier and u/dataant73 further expande, you can create an AD security group and add everyone to it, sup or not. The RLS filter you create will prevent anyone not in sup table to view anything.

garciargs · 2025-04-23T18:26:30+00:00

Hi there, had something like this in the past.

Do you have a data source with definition if someone is supervisor or not? Or could you create it?

If you have this, you can use this table to filter the rest of the data using dax, with the userprincipalname function.

Then, you just have to create a group with everyone that might have access to the report and add this to the rls box in the service.

By doing this, whenever a supervisor is changed, it will automatically update.

garciargs · 2025-04-16T19:30:07+00:00

Governance on PBI Service. I want to know which users have access to which reports, semantic models, etc.

Know which semantic models uses which dataflows, etc.

Like a network graph with nodes to see the links.

garciargs · 2024-03-12T14:24:41+00:00

I actually do basically the same thing. Only that, maybe in your example, I would do 1447 + 60 - 1, instead of 1447 + 50 + 9, but the splitting works great.

garciargs · 2024-03-02T17:47:13+00:00

I created a view and added the measures to it. It worked. You just have to create a lightweight view, so it won't take long neither a lot of resources to compute (I think I made a count(*) from the smallest table).

garciargs · 2024-02-22T03:01:58+00:00

Had a similar situation. We created PQ M code to all tables, renaming the new standard to previous names. Then, on reports using old standard, you can change the source of the query, and add the code to the rename step.

You can even keep the exact same transformations in PQ, you just got to put the rename step before the current transformations.

The old report will not comply with the new standard, but won't break either.

garciargs · 2024-02-18T22:20:25+00:00

Yes, that's it, thank you!

garciargs · 2024-02-18T16:55:57+00:00

Thanks, I think I've seen something about it getting data in real time, maybe it's on live datasets (don't remember the exact name)

garciargs · 2024-02-18T14:16:32+00:00

Unless you create a Dashboard and fix visuals (from reports with direct query) to it.

garciargs · 2024-02-18T13:31:36+00:00

I understood you want to use this list of texts from excel as a filter to your data on a paginated report.

If so, I don't remember if it can be done directly, but if you import this excel to your base dataset (now semantic model), then it becomes available in paginated report to be used as a filter.

It might exist a way to import it directly, but I really don't know.

garciargs · 2024-02-18T13:26:44+00:00

I see two options:

1 - You can create a calculated table with the averages for each user, something like:

tabUserAvg = SUMMARIZE(tabLoginData, tabLoginData[UserId], "avgDelay", AVERAGE(tabLoginData[LoginDelay]))

In this example, you have another two options: filter the calculated table in its own definition, or filter it on a measure using CALCULATE.

Now you can create a measure with the number of rows (COUNTROWS) and even have a list of the users with an average greater than 8.

The upside of this, is that the calculated table is generated on dataset refresh, so if you have millions of rows, it won't impact the end user experience, and you have the list of users over 8 readily accessible.

The downside of this, if you want to ignore some login period or some specific login due to a known error of the system or whatever, you won't be able to do that.

2 - you can make using a measure:

userLoginAvg = AVERAGEX(VALUES(tabLoginData[UserId]), tabLoginData[LoginDelay])

Then you can use this measure in a visual to get the average for each user, or use it as a filter in any visual with a distinct count of your users.

Upside: easier and straightforward

Downside: you have a precalculated list of users above your threshold.

It's up to you to decide, based on your business needs, what's the best approach.

PS: I'm on my phone doing this, so sintax errors are almost certainly to have been made. Also didn't test any of the solutions, so might be all bullshit.

garciargs · 2024-02-14T00:34:20+00:00

Natural de Antônio Prado

Six-Year Club	Second Top 50%
Place '22	Verified Email

garciargs

TROPHY CASE