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
Chinmay Patel
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

byJuan Ocasio
9
Hello Experts:

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

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

byJim Horn
12
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.  
Video
Medical Info my app made with Microsoft Powerapps 3m

Medical Info my app made with Microsoft Powerapps

by►Yolanda Cuesta Excel Contabilidad TIC
Wanting to help people keep track of which doctors/specialists they need to see, upcoming visits, …
Troubleshooting Solution

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

byLiberty4all
6
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

byroute217
3
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

byajdajd
14
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

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

Filter OData info with an Excel Spreadsheet in Power BI Desktop

byJeremy Pierce
3
I have an Odata database: https://data.texas.gov/api/odata/v4/naix-2893
And an Excel Workbook saved …
Troubleshooting Solution

Excel Zone Expert Discussion, Number 37

bybyundt
185
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

bygvamsimba
16
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

byShadow Breeze
3
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

bygvamsimba
3
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

bygvamsimba
1
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

bygvamsimba
10
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

bygvamsimba
1
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

bygvamsimba
3
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)

byRIAS
7
Hello,

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

byRIAS
5
Hi,
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?

bySal Overmars
2
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

bysvs1919
7
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

Collaborate

Monitor your Site

Explore solutions and more