Can I use DAX to create predictive charts?
I need to show a basic linear trend line for the next 6 months of sales. Can I do this entirely in DAX, or should I be using the analytics pane and built-in forecasting? Which method is more accurate ...
Should I use bidirectional cross-filtering in my data model?
I keep reading that bidirectional cross-filtering is generally bad practice, but I have a scenario where I need to filter a dimension based on another dimension. My current model is failing to return ...
Is it safe to store credentials in Power BI?
I am setting up a gateway for an on-premises SQL database. I am worried about the security implications of storing the database credentials in the Power BI service. What are the best practices for han...
Can I use Python for data modeling?
I am much more comfortable with Python than DAX. Can I do my data modeling and cleaning in Python and feed it into Power BI? Will this affect the ability of the report to use slicers and interact with...
How to handle nulls in DAX calculations?
My data has a lot of null values, and it is messing up my averages and percentage calculations. How do I handle these effectively without deleting rows? Should I use COALESCE, IF(ISBLANK), or some oth...
Why is my filter context behaving unexpectedly?
I am struggling to understand why my measure is ignoring certain filters in the report. I have a slicer for 'Product Category' but when I select something, the chart doesn't react. I suspect something...
Are variables faster than multiple calculate statements?
I see many experienced developers using VAR and RETURN in their DAX. Does this actually improve performance or is it just for readability? I have a measure that references itself multiple times, and I...
What is the best way to handle 'unknown' members?
I have data that doesn't match my dimension tables, resulting in '(Blank)' values in my reports. Should I handle this in Power Query by adding a dummy row, or is there a better way to do this in DAX t...
How to detect circular dependencies?
I keep getting an error about circular dependencies in my model. I've looked at my measures and tables, but I can't find the loop. Is there a way to visualize the dependency chain, or a tool that can ...
Is my data model schema too wide?
I have a table with over 100 columns. I am getting warnings about model size, and the file is becoming huge. Should I be removing unused columns, or does Power BI handle them effectively if they aren'...
