Explore Power BI on Experts Exchange

Expert Solutions for Your Tech Problems

Power BIPower BI

Power BI is a business analytics tool from Microsoft used for data visualization. It integrates seamlessly with other tools, like Microsoft Excel, ...

Read more
  • 407 Content
  • 221 Contributors

Expert Spotlight
Chief Technology Ninja

A Tech Start-up Owner 24x7x365 :) ... Geeky, Matrix Fan, Love To Travel And Explore Exotic Places.

Troubleshooting Solution

Creating relationships between tables with no common columns in Power BI

Hello Experts:

I have several tables that I want to create a visual for.  Two of the tables are …

Microsoft Excel & SQL Server:  Self service BI to give users the data they want

How to build an Excel spreadsheet that allows users to enter select values via populated combo boxes and hit a magic ‘Go’ button that retrieves only that data from SQL Server based on those selections, using nothing more than standard Microsoft Excel functionality and an ODBC Connection.  
Troubleshooting Solution

Need help adding a trend line to line graph in Power BI Desktop

I'm trying to add a trend line to the following graph and cannot find a way to do this.  I have …
Troubleshooting Solution

Convert a Power Formula into SQL Syntex

Hi Experts

What is the SQL equivalent of the following DAX (Power BI) Formula
AOV = …
Troubleshooting Solution

Creating a calculated column from two tables in Power BI

I'm having difficulty creating a calculated column.  I've attached the table layout for the three …
Troubleshooting Solution

Need help getting dates to appear on X axis in Power BI

I'm trying to create a line graph in Power BI but am not able to get individual dates to appear on …
Troubleshooting Solution
Troubleshooting Solution

Excel Zone Expert Discussion, Number 37

This thread is for general discussion about all things related to the Excel TA and its experts. Both…
Troubleshooting Solution

Getting data for last week Monday - Sunday in Powerbi

Hi, I have to display count of custid's based on Purchase date for last week (monday -Sunday) and …
Troubleshooting Solution

Power BI - Column Chart - X-axis won't sort by Month-Year

I have a table of help desk tickets.  Each ticket can have multiple transfers taken on it and the …
Troubleshooting Solution

dax divide by number number of weeks left in the financial year

Hi I have a measure 1 . I need to create 2 measures with the below formula. our Financial year is …
Troubleshooting Solution

Evaluating the VALUE of the Variable in DAX

Hi, can someone please explain me how to check the value returned by  a variable in DAX ?

I am using …
Troubleshooting Solution

PowerBI getting data for last 7 days

Hi, I am working on a PowerBI report and I need to do count of customers who made orders in the last …
Troubleshooting Solution

DAX query for COUNT for YTD

Hi, I have table with custid, createddate and cancelled date. I want to create a calcualted measure …
Troubleshooting Solution

CASE statement equivalent to in DAC

hi , I m developing a powerbi matrix report and my row data is a look up column and I have to group …
Troubleshooting Solution

How to connect Power BI to a RDP sql server ( it is on a different domain)


I can connect to server ( different domain) via VPN  or RDP.
Not sure how can I connect to the …
Troubleshooting Solution

Dataflow in Power BI service

Any suggestions on dataflow from Power BI desktop to Power BI dashboard and reports in …
Research Solution

Is there anyway to export data from power bi to excel?

I need to export data from a table in power bi that has millions of rows, I know SSRS can do it but …
Troubleshooting Solution

Power BI DataModel

Hello Experts,
In a Power Bi report I have 2 tables , 1 table has monthly store sales and other table …

Do more with Experts Exchange.

Get Answers

Join a Group Discussion


Monitor your Site

Explore solutions and more