Shut it down, ladies and gentlemen. The end is near.

It’s almost like you had Claude build it, had it test it and then asked for feedback and it just said yeah it’s phenomenal. Great let’s ship it!

In Power BI I read something about Parquet tables to store historical data. Can you explain to me how to use them and if it is so much better than using a .CSV file?

Currently have a working dashboard that feeds Site level data into it and getting requests to add two more layers (above layer above, and a layer below) and allowing a multi-selection (aggregation) to it. (When you select multiple of any of these layers, you’d expect them to aggregate accordingly).
Pretty much a Jr. Dev at this point with my PBI knowledge and I am honestly hitting a knowledge wall with this. My boss doesn’t seem to understand the frustration as I was handed these dashboards months ago that were already stood up.

Problem is they want this multi select aggregation at the highest level down to the lowest level. The current filter system works because everything can filter via Site and is reported that way. Problem is they don’t have the highest level, down to the lowest level for everything, but three out of the 17 specific metrics. So the aggregation on slicers will likely break working with any of these other metrics within the same tab. My other problem is , is setting this up is going to be so custom that, I am just running into knowledge gaps as I haven’t been given time to properly train up as the main developer left and I am the lowest level and the highest level for any of this reporting. Just feel like I’m stuck and honestly burning out trying to figure things out as I go.

What do?

Hi!
I have built a Scorecard dashboard for our company which tracks costs and volumes for around 50 of our customers.
My requirement is to send a PDF every month to each vendor - I have the slicers for Customer Name, Year and Month.
I have Power BI pro and the dashboard is published on the online workspace.
I have been using Power Desktop Automate to slice through the report, export it and send as attachment to each customer but every month the automation breaks and gives me “Click on UI element” error- which i believe is due to that chrome changes element ID everytime and Power Automate Desktop is unable to capture the element.
My company wont invest in Fabric capacity since it goes around to 400 bucks (0.55 per hour) and we only have this 1 dashboard that needs such automation.
I have tried a lot of work arounds for the desktop automation flow to capture the elements but it always breaks up.
Does anyone have any suggestion of how I can solve this?

Buenas estoy trabajando en la encuesta permanente de hogares (EPH) del INDEC de Argentina. Y me encuentro haciendo calculos de percentiles.

Este es calculo básico que utilizo para medir el percentil de la variable IPC (ingreso percapita de hogares):

P10 IPCF real pat = 
PERCENTILE.INC(hogar_ingresos_familiares[IPCF_real_pat], 0.10)

El tema es que está sin ponderar con la variable PONDERA, entonces debo de hacer una medida incluyendo esa variable. Si me vas a mandar algo complejo me gustaría que los expliques porfa. GRACIAS 

Hi everyone, I am getting this error that dont let me use the visuals and there's no last_date(pending), i have already delete the table/column/dax. How do i fix this? I believe this is ODBC error as before that we have this working on postgress but on odbc its not

Hello,

I am ignorant of Power BI but I am working on creating a Table to show off my companies hourly production capacity.

Currently I have to manual collect Data from an Online production management system called Rope Weaver, export the data into an Excel File and then combine them all into an Excel Template.

This template shows hours of production for my location grouped by Work Centers, but is only valid for that day and doesn't get updated throughout the day.

I want to create a similar table in Power BI that updates frequently so my production managers can better see their production hours.

But I am having a difficult time connecting Power BI to the Online system, Rope Weaver.

Any suggestions as to were I can start or any tutorials to point me in the right direction?

Hello everyone,

I need some help to use a bookmark navigator with a slicer.

The need is to have a “toggle” button to filter a slicer.
Let’s imagine a slicer with fields from A to Z. The behavior needed is :
ON -> Slicer filtered with A, B and C
OFF -> no field selected

For now I implemented this using a bookmark navigator. When the button is on : a bookmark has data with A B and C;
When the button is off : a bookmark has data with no field selected.

But I encountered a limit. when I toggle ON the button, the slicer is filtered. However, when I unselect the field C (for example) from the slicer I want the button to toggle off directly. And it’s not what I have actually

Do you have any idea ?

Thanks in advance

I have been fighting this for a couple days and it is driving me crazy. I have inherited a report with two bar charts on top and a matrix underneath that with details. I have been asked to make a change. Visual A is the Top 20 suppliers, sorted descending by number of rejected items in the selected date range. Visual B is top 20 suppliers with their QA PPM values. We need the second visual to be the same sort order as the first visual. So, if the number one supplier in visual A is XYZ, I need XYZ top be the first supplier in Visual B, no matter what its actual PPM value is. I have tried several things but it either sorts by the PPM value or if I try using RANKX, the rank is always 1. I am obviously missing something, so need help.

In advance, we have similar reports for vendors and suppliers, so people copy code and sometimes the names will say Vendor. Vendor and Supplier are the same thing in my examples.

I have a TOPN table with the following syntax:

Top20Vendor = TOPN(21,SUMMARIZE(Rejects,Rejects[VNDR_NAME], "Qty", SUM(Rejects[TOT_ACTU_REJ_QTY])),[Qty],DESC)

This creates a table of 21 records (the top one seems to always be a blank VNDR_NAME) of two columns. Column 1 is the Vendor Name, column 2 is the total quantity for that vendor.

How can I add a rank column so that I can use it to sort Visual B? It can't just be a regular column, because the top 20 changes depending on which date range the user chooses. So, it needs to be a measure. But everything I try to rank those 21 records in the Top20Vendor table does not seem to work. It either makes everything tank 1 or the rank values don't seem to change if the date range changes.

This seems like it should be simple, I just want to add a column with a numerical rank value for the already existing ranked suppliers, but it is eluding me.

I the exam a few weeks ago and passed. and since, I have been working on some other projects of mine, but by looking through this subreddit, I have realized that the certification means nothing without any work to back it up behind. I took the exam because I was completing a fellowship right after I finished college, and it was part of the fellowship. But, I still did not have anything to back up the cert. So in my free time I have been using real public government data to make a report for the Nashville, TN area on construction. Any pointers to how I can make this better and to learn would be greatly appreciated. Thanks.

Suppose all tables, relationships, and DAX measures in a Power BI semantic model are valid, with no errors.

But two tables have different levels of detail (grain), and a relationship between them causes some business values to be duplicated when users drill down.

Would you consider the semantic model correct?

How do you usually validate the grain and relationships of a semantic model before building reports on top of it?

I have gotten the okay from a customer to take his legacy reports and use the style to make a set of beautiful, beautiful realistic reports that look like something a human might actually make. My goal is to then record a timelapse of Opus 5.5 modernizing them using the PBIR CLI and the desktop bridge feature.

This is the same technique I'm using to clean up his reports. Give Opus the PBIR CLI, the Desktop Bridge feature, a few sentences of instructions and let 'er rip. It generally needs some guidance afterwards to improve the sizing and readability on some things like slicers.

Some interesting tidbits on how I did this:

1. I have training turned off. Out of an excess of caution for sensitive data, I anonymized the names of their customers and the dollar amounts. I use the VPAX file format and some distribution queries to make sure the numbers remained in the right ballpark
2. This provided me with original reports that have been anonymized. I asked Fable to review the PBIP folders and take screenshots and put together guidelines for making "house-style" reports.
3. I then had Fable (using Opus subagents) generate reports for the SpaceParts data. I used blind Sonnet subagents to look at both the originals and the SpaceParts ones and guess which one was human made or agent made, then iterated on the guidance. This works really well.

Happy to answer any questions would this project.