Recent questions tagged power-bi

0 votes
1 answer

I need a scatter plot where the x-axis and y-axis dynamically change based on slicer selections—how can I achieve this?

Mar 18 in Power BI by Evanjalin
 • 32,290 points • 215 views
0 votes
1 answer

How do I create a dynamic KPI card that changes color based on user-selected thresholds?

Mar 17 in Power BI by Evanjalin
 • 32,290 points • 238 views
0 votes
1 answer

How can I create a function in Power Query that processes data differently based on a user-selected parameter?

Mar 17 in Power BI by Evanjalin
 • 32,290 points • 197 views
0 votes
1 answer

How can I create a dynamic grouping in Power Query where the group sizes vary based on another column’s values?

Mar 17 in Power BI by Evanjalin
 • 32,290 points • 221 views
0 votes
1 answer

How do I optimize a complex Power Query transformation that takes too long to refresh?

Mar 17 in Power BI by Evanjalin
 • 32,290 points • 240 views
0 votes
1 answer

How do I extract JSON data from an API and transform it into a structured table in Power Query?

Mar 13 in Power BI by Evanjalin
 • 32,290 points • 167 views
0 votes
1 answer

How can I create a rolling calendar table that updates automatically based on the latest data in my fact table?

Mar 13 in Power BI by Evanjalin
 • 32,290 points • 221 views
0 votes
1 answer

How do I create a Power Query function that dynamically adjusts based on input parameters?

Mar 13 in Power BI by Evanjalin
 • 32,290 points • 188 views
0 votes
1 answer

I have a dataset where column data types change frequently—how can I create a dynamic transformation process?

Mar 13 in Power BI by Evanjalin
 • 32,290 points • 137 views
0 votes
1 answer

How do I handle dynamically changing column names in Power Query without breaking my transformations?

Mar 13 in Power BI by Evanjalin
 • 32,290 points • 194 views
0 votes
1 answer

I need to merge two tables in Power Query but maintain a one-to-many relationship—what’s the best approach?

Mar 11 in Power BI by Evanjalin
 • 32,290 points • 286 views
0 votes
1 answer

My performance analyzer shows a high DAX query time—how can I optimize my measures?

Mar 11 in Power BI by Evanjalin
 • 32,290 points • 177 views
0 votes
1 answer

What’s the best way to handle slow row-level security (RLS) filters applied to large datasets?

Mar 11 in Power BI by Evanjalin
 • 32,290 points • 184 views
0 votes
1 answer

How can I reduce the dataset size of a Power BI model that keeps hitting memory limits on Power BI Service?

Mar 11 in Power BI by Evanjalin
 • 32,290 points • 205 views
0 votes
1 answer

Why does my Power BI report take so long to refresh when using multiple complex calculated tables?

Mar 11 in Power BI by Evanjalin
 • 32,290 points • 213 views
0 votes
1 answer

What’s the best way to index my SQL database to speed up DirectQuery performance in Power BI?

Mar 11 in Power BI by Evanjalin
 • 32,290 points • 170 views
0 votes
1 answer

How do I create an optimized star schema for Power BI when dealing with high-cardinality dimensions?

Mar 11 in Power BI by Evanjalin
 • 32,290 points • 166 views
0 votes
1 answer

How do I improve query performance when working with large fact tables in DirectQuery mode?

Mar 11 in Power BI by Evanjalin
 • 32,290 points • 176 views
0 votes
1 answer

My Power BI report is slow when using multiple DISTINCTCOUNT() measures—what optimization techniques should I use?

Mar 10 in Power BI by Evanjalin
 • 32,290 points • 203 views
0 votes
1 answer

How can I reduce the memory usage of a complex DAX calculation that involves multiple SUMX() iterations?

Mar 10 in Power BI by Evanjalin
 • 32,290 points • 173 views
0 votes
1 answer

How do I dynamically switch measures in Power BI based on a slicer selection while maintaining performance?

Mar 10 in Power BI by Evanjalin
 • 32,290 points • 229 views
0 votes
1 answer

I want to calculate the distinct count of active customers but only for the last three completed months—how can I do this in DAX?

Mar 10 in Power BI by anonymous
 • 32,290 points • 243 views
0 votes
1 answer

How can I optimize a SUMX() function that is performing poorly on large datasets?

Mar 10 in Power BI by Evanjalin
 • 32,290 points • 166 views
0 votes
1 answer

My calculated column works in Power BI Desktop but breaks when I switch to DirectQuery mode—why?

Mar 10 in Power BI by Evanjalin
 • 32,290 points • 251 views
0 votes
1 answer

How can I create a measure that calculates the weighted average of a column dynamically based on slicer selections?

Mar 10 in Power BI by Evanjalin
 • 32,290 points • 227 views
0 votes
1 answer

How do I handle many-to-many relationships in Power BI without creating ambiguous relationships in the model?

Mar 10 in Power BI by Evanjalin
 • 32,290 points • 179 views
0 votes
1 answer

I need to calculate a running total but reset it at the start of each new quarter—how can I achieve this in DAX?

Mar 7 in Power BI by Evanjalin
 • 32,290 points • 244 views
0 votes
1 answer

How can I create a dynamic date range filter that automatically adjusts based on user-selected slicer values?

Mar 7 in Power BI by Evanjalin
 • 32,290 points • 244 views
0 votes
1 answer

Your Power BI dataset has millions of rows and is causing memory issues. How can you reduce the dataset size without losing key insights?

Mar 7 in Power BI by Evanjalin
 • 32,290 points • 220 views
0 votes
1 answer

A dataset contains customer transactions, and your report is aggregating data at multiple levels (daily, monthly, and yearly). Should you use Import Mode or DirectQuery for optimal performance?

Mar 7 in Power BI by Evanjalin
 • 32,290 points • 197 views
0 votes
1 answer

Your dataset contains multiple fact tables (Sales, Inventory, and Finance). Should you create relationships between them directly, or use a bridge table? Why?

Mar 7 in Power BI by Evanjalin
 • 32,290 points • 205 views
0 votes
1 answer

Your Power BI report is slow when switching slicer values, and your DAX measures are using FILTER extensively. What steps can you take to improve performance?

Mar 6 in Power BI by Evanjalin
 • 32,290 points • 216 views
0 votes
1 answer

You are working with a large dataset (10M+ rows) and your Power BI report is taking too long to refresh. How can you optimize it for better performance?

Mar 6 in Power BI by Evanjalin
 • 32,290 points • 223 views
0 votes
1 answer

A client needs a map visualization showing sales per city, but the dataset lacks latitude/longitude coordinates. How can you ensure accurate city placement in Power BI?

Mar 6 in Power BI by Evanjalin
 • 32,290 points • 159 views
0 votes
1 answer

The client wants a KPI card that displays “Sales Performance” in red if below target, yellow if close, and green if above target. How can you achieve this in Power BI?

Mar 6 in Power BI by Evanjalin
 • 32,290 points • 193 views
0 votes
1 answer

Your report contains multiple visuals, but users are getting confused when they filter data because they don’t know which filters are applied. How can you improve the user experience?

Mar 6 in Power BI by Evanjalin
 • 32,290 points • 169 views
0 votes
1 answer

Implementing a Slicer to Toggle Between Daily, Monthly, and Yearly Sales Aggregation

Mar 5 in Power BI by Evanjalin
 • 32,290 points • 211 views
0 votes
1 answer

Filling Missing Values with the Previous Available Value in Power Query

Mar 5 in Power BI by Evanjalin
 • 32,290 points • 247 views
0 votes
1 answer

Handling Text-Based Date Columns with Errors in Power Query

Mar 5 in Power BI by Evanjalin
 • 32,290 points • 291 views
0 votes
1 answer

Standardizing Customer Names to Proper Case in Power Query

Mar 5 in Power BI by Evanjalin
 • 32,290 points • 210 views
0 votes
1 answer

Automating Monthly Sales Data Consolidation from SharePoint

Mar 5 in Power BI by Evanjalin
 • 32,290 points • 145 views
0 votes
1 answer

Comparing Year-to-Date (YTD) vs. Previous Year YTD in a Financial Dashboard

Mar 5 in Power BI by Evanjalin
 • 32,290 points • 173 views
0 votes
1 answer

Categorizing Employees Based on Sales Performance

Mar 5 in Power BI by Evanjalin
 • 32,290 points • 159 views
0 votes
1 answer

How to Calculate Dynamic Regional Sales Percentage in DAX?

Mar 3 in Power BI by Evanjalin
 • 32,290 points • 175 views
0 votes
1 answer

How to Calculate Total Sales for the Last 3 Months Dynamically in DAX?

Mar 3 in Power BI by Evanjalin
 • 32,290 points • 224 views
0 votes
1 answer

Is it possible to store data in Power BI statically so that it remains unchanged after a data refresh? If so, how can this be implemented?

Mar 3 in Power BI by Evanjalin
 • 32,290 points • 185 views
0 votes
1 answer

Is there a way in Power BI Desktop to transform multiple text column values into a single row, grouped by another column?

Mar 3 in Power BI by Evanjalin
 • 32,290 points • 178 views
0 votes
1 answer

What are the steps to properly configure permissions for an application to access Microsoft Fabric services, and what common issues should I watch out for?

Feb 28 in Power BI by Evanjalin
 • 32,290 points • 221 views
0 votes
1 answer

Why do I get a 401 (unauthorized) error when using a service principal access token to call the Users.GetUserArtifactAccessAsAdmin API in Power BI?

Feb 28 in Power BI by Evanjalin
 • 32,290 points • 577 views
0 votes
1 answer

What are the steps to create and customize a Waterfall chart in Power BI?

Feb 28 in Power BI by Evanjalin
 • 32,290 points • 265 views
Page:

Most popular tags

"PMP®","PMI®", "PMI-ACP®" and "PMBOK®" are registered marks of the Project Management Institute, Inc. MongoDB®, Mongo and the leaf logo are the registered trademarks of MongoDB, Inc.