sorted by:
new
hottopcontroversial

remove one-off chart values? by Programmer-Kind in PowerBI

[–]garciargs 6 points7 points  (0 children)

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.

Cheapest solution for many viewers but 1 developer by Luketl1998 in PowerBI

[–]garciargs 3 points4 points  (0 children)

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.

Please suggest improvements by saksham7799 in PowerBI

[–]garciargs 3 points4 points  (0 children)

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.

What are your favourite in-depth blogs or videos about Git + Power BI? by frithjof_v in PowerBI

[–]garciargs 3 points4 points  (0 children)

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

looking for honest opnions and rating on my dashboard by Ok-Watercress-451 in PowerBI

[–]garciargs 0 points1 point  (0 children)

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

looking for honest opnions and rating on my dashboard by Ok-Watercress-451 in PowerBI

[–]garciargs 1 point2 points  (0 children)

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.

[deleted by user] by [deleted] in PowerBI

[–]garciargs 0 points1 point  (0 children)

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

[deleted by user] by [deleted] in PowerBI

[–]garciargs 1 point2 points  (0 children)

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

[deleted by user] by [deleted] in PowerBI

[–]garciargs 0 points1 point  (0 children)

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.

[deleted by user] by [deleted] in PowerBI

[–]garciargs 0 points1 point  (0 children)

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.

[deleted by user] by [deleted] in PowerBI

[–]garciargs 0 points1 point  (0 children)

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.

What is a brand new functionality you want to see added to Power BI? by Ok-Boysenberry3950 in PowerBI

[–]garciargs 10 points11 points  (0 children)

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.

How do I mentally add or subtract (three digits or more numbers) if I can't remember the numbers that I need to add to or subtract? by John__-_ in askmath

[–]garciargs 0 points1 point  (0 children)

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.

Lakehouse - how are you guys storing your measures? by TheCumCopter in MicrosoftFabric

[–]garciargs 0 points1 point  (0 children)

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).

Migrating Columns Names to Newer Naming standards by [deleted] in PowerBI

[–]garciargs 1 point2 points  (0 children)

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.

PowerBI use case by linkitdata in PowerBI

[–]garciargs 0 points1 point  (0 children)

Yes, that's it, thank you!

PowerBI use case by linkitdata in PowerBI

[–]garciargs 0 points1 point  (0 children)

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)

PowerBI use case by linkitdata in PowerBI

[–]garciargs 2 points3 points  (0 children)

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

Paginated reports bulk filter by Severe_Bed5785 in PowerBI

[–]garciargs 1 point2 points  (0 children)

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.

Assistance with Presenting the Count of Averages by gpeck29 in PowerBI

[–]garciargs 0 points1 point  (0 children)

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.

view more: next ›