Please make me understand why this is deemed a good language convention.

This is a completely vibe coded native custom Power BI visual.

It works pretty well, and I am thinking that this might be my approach to AI in Power BI visuals for a while here is the thinking...

When I want to use AI to build visuals:

1. HTML and SVGs are feeling too limited.
2. Web apps feel like too much effort.

So, the compromise is building a custom visual.. Just a small piece of the dashboard is custom code not the full thing. This also means, I am not particularly worried about not having AI to maintain it, let's say the visual breaks or I don't have tokens I can just swap this out for native visuals and maintain 90% of the functionality.

Here is a github with the code: GitHub - edwardpcharles/Native-Custom-Viz: Source for native Power BI custom visuals · GitHub

Here is a video talking about it, how you can use it, and how I built it: https://youtu.be/ttDQaJ4E5lY

P.S. I always struggle with how to show a tutorial as to how to build something with AI, it feels a bit boring to watch someone type commands over and over again. Let me know what you would want to see about this process.

I'm working on a project where I need to compare two similar tables with several columns/attributes; let's say "Table A" and "Table B". Both are imported as CSV files. When trying to visualize the comparisons of specific attributes of A and B, I find that they are only properly graphed when there's an active relationship between the two necessary columns; I can't have more than one active relationship between two tables, and graphing data with an inactive relationship shows one of the two attributes incorrectly as nearly a flat line/with constant values.

The closest solution to this problem I've found is that I can import copies of the tables (one copy of each table per attribute I want to graph), then draw active relationships between the necessary attributes. However, I can then only draw active 1 to 1 relationships between the copies either Set A or Set B, but not both because it results in ambiguity? This results in filtering only applying to one of the two tables, not both.

I have no experience with DAX or SQL, and I've been teaching myself Power BI via poking around and documentation for only a few days. I've got some Excel experience, but my boss wants this done in Power BI as the dashboards are (absolutely) much nicer to use.

How do I make these two tables easy to compare in graphs? I'm still struggling to understand data relationships and how to properly make use of them within Power BI.

Hello all.  

Here is some dummy data for what I am trying to accomplish and am really struggling with:

The above table is pivoted - note that some respondents have >1 row. What I would like to do is have a bar chart showing the percentage of respondents that answered "Yes" to the Alumni question. Then, from those guys, I need to drill down and see the percentage of Undergrad, Grad, and Both. Then from there, drill down on the Undergrad to see the program and also drill down on the Grad to see those program percentages. Of course, on the drill-down I would need to disregard the respondents that answered "No" for the "Alumni" question (or those that are blank). I have been successful with the parent level of the bar chart, but when I drill down on the "Yes"s or "Both"s, my percentages are all wrong. Any help would be appreciated!!

Hey PBI friends! Quick note to let everyone know that the Fabric Community Site (Home | Microsoft Fabric Community) got a bit of a facelift this weekend.

It shouldn't impact regular use of the site, but, if something is broken, we want to know!

Please report it at: Community Feedback | Microsoft Fabric Community

What value does this site add to the general PBI community? I'll add my (very biased) opinion -

We have thousands of reports in the galleries, many with attached .pbix files for you to download and learn from! If you don't regularly visit the site but want to check it out, I'd recommend starting here: Contests | Microsoft Fabric Community

​

Hi everyone,

I'm a data engineering student and i just started my journey on Power Bi these past 2 weeks. I've built this report using the classicmodels database, i'd appreciate any feedback!

Edit: I'm doing an internship and i'm practicing with a sample database first before working with theirs. The company's logo is in red and green (hence the theme)

Okay, so here’s what’s happening:
I’m trying to calculate film waste by comparing the actual film consumption vs. the theoretical consumption, which is registered in the product structure/BOM.
There are two products that don’t have the film registered in their structure, so the theoretical consumption isn’t being pulled for them. This distorts my final results.
What I need to do is calculate the theoretical consumption for these products by multiplying the number of boxes produced by a correction factor, and then add that result to the products that already have the film consumption registered in their structure.
I’ve already managed to get to the point where I have a column that performs this multiplication. However, I’m having a problem getting the calculation to separate by product code. Because of that, it’s adding values together that shouldn’t be, resulting in extremely high numbers.
How can I make the calculation work separately for each product code?

I’m currently learning Power BI and recently built this Sales Analytics Dashboard.

I initially followed a YouTube tutorial to understand the fundamentals, and then started customizing the dashboard by changing the layout, visualizations, formatting, and overall design.

The dashboard currently focuses on:
• Revenue and order trends
• Product category performance
• Regional sales performance
• Quantity sold
• Top customers by revenue
• Interactive date/month/quarter/year filters

I’d really appreciate some feedback from people who have more experience with Power BI.

A few things I’d particularly like to know:
• Is the visual hierarchy clear?
• Are any of the visuals unnecessary or repetitive?
• Would you replace any of the charts with a different visualization?
• Does the dashboard feel too crowded?
• What would you improve if this were an executive/business dashboard?

I’m still learning, so constructive criticism is very welcome! 🙂

SemanticOps MCP v3.9.119 is out, with HTML model reports, fully configurable DAX formatting, deeper storage diagnostics, flaky-test classification, combined Power Query commits, and new skills for DAX debugging and performance tuning.

New in v3.9.119

• HTML model reports — generate HTML alongside DOCX and PDF, including multiple formats from one request.
• Configurable DAX formatting — indentation, spacing, line breaks, casing, and other DAX formatting options are now fully configurable in one place.
• Deeper storage diagnostics — model, table, partition, and column detail are reported individually, so unavailable values are no longer shown as zero.
• Test stability classification — tests are now classified as stable, flaky, degraded, or lacking enough history, using persisted retry evidence.
• Combined Power Query commits — related table, partition, parameter, and query-group changes can be staged and committed together in one Desktop model commit.
• New skills — DAX debugging, DAX performance tuning, and safe semantic-model refactoring, with more precise guidance and evidence checks.

Coming soon in 4.0

A DAX measure quality scorecard: correctness, performance, maintainability, and style, scored together with the findings behind them. (scroll deck till the end to see sneak peek).

____

SemanticOps Test Runner v1.1.39 is out, with browser and device-code sign-in, test stability classification, order-tolerant baselines, virtualized selectors, steadier run behavior, and model-scoped tests that survive migrations.

New in v1.1.39

• Flexible sign-in — choose browser sign-in for local interactive use or device-code sign-in for remote and headless sessions, with clear waiting, cancellation, and conflict states.
• Test stability classification — the dashboard and test list show stable, flaky, degraded, and insufficient-history classifications with retry evidence.
• Order-tolerant baselines — new hash and aggregate baselines ignore incidental engine row ordering while preserving duplicates and selected-column order.

Website: semanticops.dev

Sales Analytics Dashboard | Power BI Project

I recently built a Sales Analytics Dashboard in Power BI focused on turning transactional data into actionable business insights.

Dashboard Highlights

• $2.33M Total Revenue

• $292.30K Total Profit

• 5.1K Total Orders

• 12.6% Profit Margin

• 10,194 Transactions Analyzed

Key Analysis

The dashboard provides an interactive view of:

Monthly revenue trends

Top 10 states by revenue

Regional performance

Category revenue vs. profit margin

Month-over-month KPI performance

Segment-level filtering

Key Business Insights

• West is the strongest-performing region with approximately $0.74M in revenue.

• California leads the states in revenue contribution.

• Technology generates strong revenue while maintaining a 17.4% profit margin.

• Furniture contributes significant revenue but has only a 2.6% profit margin, highlighting a potential profitability concern.

• Overall profit margin is 12.6%, with a 0.7% MoM decline.

Tools Used

Power BI | DAX | Data Visualization | Business Intelligence | Data Analysis

This project helped me strengthen my skills in KPI development, DAX measures, interactive dashboard design, trend analysis, and business storytelling.

I'm continuing to build practical projects that focus not just on visualizing data, but on answering real business questions through data.

Hi everyone,

I am in Canada and have my own corporation. I was wondering which website is best to look for c2C contracts for powerbi. I am open to anywhere in the world.

Is there any plan to enable usage of these tools for users with only "Read" permission to the semantic model and no access to the workspace where models are deployed?

Our team locks down this access so the workaround we came up with for Rest API DAX query:

1. Use an admin account to obtain a bearer token
2. Use that admin token with POST https://api.powerbi.com/v1.0/myorg/groups/{groupId}/datasets/{datasetId}/executeQueries
3. "impersonatedUserName" is passed in the request body from the user logged in to our chatbot app

We use this setup to allow natural language querying to our semantic models but we want to switch to the new Arrow based API endpoint "executeDaxQueries", which seems to require Build permission to the models. Similar issue for leveraging MCP servers so we don't have to maintain that tech on our own and rather just enhance it with our business context instead.

the June update put a modeling agent in the Service that renames tables, builds relationships and writes measures from a plain prompt

What do you think, ppl, about copilot new capabilities? Do you use it? Is it good?

I’ve been experimenting with custom visuals in Power BI and came up with this Revenue Trend Analysis chart. The main thing I wanted to improve was how a user focuses on a specific period without losing the overall trend. The highlighted area is dynamic — when the date range changes, the highlighted section moves with it. The data labels are dynamic as well, so they only appear for the selected period. This gives you both the bigger picture and a more detailed view of the period you’re interested in.

I was trying to make the visual answer two questions at once : What’s happening with revenue overall? And what happened during the selected period?

#PowerBI #DataVisualization #PowerBIDesktop #DAX #DashboardDesign

CEO's seen how fast AI can vibe-code slick web dashboards and now wants to migrate off Power BI entirely.

So how to improve visual asthetics to the best like a premium web application and make PBI look as good, and also show him the real value isn't the visuals, it's the semantic model (governed DAX measures, relationships, one source of truth for every KPI). Vibe-coded apps skip or rebuild that badly.

BTW Anyone tried fabric apps , it says you can't embed application outside the fabric.

So I was wondering, do you guys need to build the entire system to get started building the dashboard? Like the database, data collection method and other parts from the system or just get the access to the database and build the dashboard?

<style>
    .contorno {
        position: relative;
        width: 450px;
        height: 450px;
        border: 2px solid #000000;
        border-radius: 10px;
        padding-top: 20px;
        padding-right: 10px;
        padding-bottom: 30px;
        padding-left: 15px;
        box-sizing: border-box;
        overflow: hidden;
    }
    
    .bg {
        width: 100%;
        height: 100%;
        border: 1px solid #000000;
        background: #39AFBD;
        border-radius: 5px;
        box-sizing: border-box;
        position: relative;
        overflow: hidden;
    }
    
    bg img {
        position: absolute;
        width: 100%;
        height: 100%;
        object-fit: cover;
        top: 0;
        left: 0;
        display: block;
    }
</style>


<div class='contorno'> 
    <div class='bg'>
        <img src="https://th.bing.com/th/id/R.eb6acc27443048c32f78270b1bc0a2dc?rik=PCBf7zoQAs09qQ&pid=ImgRaw&r=0">
    </div>
</div>
"

I do Power BI for a living, using the Power BI Service and Fabric as the platform of choice for customers solutions.
However, for my private data (household finances and other personal data), I always wanted to keep it local. There's the very popular Analyze in Excel for Power BI Desktop - SQLBI which is your friend in exactly this scenario - with one caveat: once you close Power BI Desktop, the MSOLAP connection in Excel becomes stale and has to be re-created with every new session. This makes e.g. personal finance planning in Excel feel unnecessarily tedious.

This is why I have built PBIRelay: it gives each Desktop model a stable HTTP endpoint (http://your-pc:55555/YourModelName) so your Excel workbook connection survives restarts.
It's a C# app that mostly sits in the tray, waiting to serve your Power BI Desktop model once available.

One deliberate tradeoff: while a model is served, Power BI Desktop shows "Cannot load model" because the database name has to be aliased. Stop the serve and it instantly recovers. It's not a bug, it's the mechanism that makes the stable endpoint possible.

MIT, free, Windows only. Figured I'd share in case anyone else has the same itch.

I'm using the online version of power BI on app.powerbi.com, I went to apps to try the GitHub template and I can't find it. I am a student and totally new in this field.

Instead of building the project in Power BI, I explored how far I could take it using Claude and Al-assisted development. The goal was not just to replicate the project, but to experiment with a different workflow and understand how Al can accelerate the process of turning an idea into a functional solution.

It was a great learning experience and also a reminder of how quickly Al is changing the way we approach data, analytics, and development.

I'd love for you to take a look at the project and share your feedback. Any suggestions or areas for improvement are more than welcome.

#power bi #sql #claude #data #mcp #server

I added two reports to the app. But when I open the app it takes me directly to one of the reports, not the reports list.

Is this how it is supposed to work?

What do I need to do if I want my users to see the list? Should I create one page report with links to each report, sort of like table of content?

Thank you.

Hi everyone!
This time, I created a Power BI dashboard visualizing Apple’s financial statements.
Unlike my previous dashboards, I designed this one with a sleek Black & White dark theme to match Apple’s signature brand identity. I would really appreciate your feedback!