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
  • 652 Content
  • 242 Contributors

Expert Spotlight
David H.H.Lee
Digital Marketing (Hospitality)

Focus on what matters and Let Go OFF what doesn't.

Troubleshooting Solution

Power BI order chart by Year-Month

byMurray Brown
7

Hi

In Power BI I have the chart below where I want to sort by "Month Year". I cannot see the data

…
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

Power BI Reports and Dashboards

byMurray Brown
3

Hi

In Power BI I want to create a report from a dashboard. How do I do this? What is the difference

…
Troubleshooting Solution

Move SSRS Reports from SQL to Power BI

byroute217
6

Hi Experts


I am trying to copy all my SSRS Reports in SQL to Power BI (paginated) i.e re-create them

…
Troubleshooting Solution

Power BI - protecting embedded reports from people outside the organization

byMurray Brown
2

Hi

I have a Power BI report that I am going to embed in my ASP.net web app. How do I keep the actual

…
Troubleshooting Solution

Power BI - DAX how to get the Average days between two dates?

bySQL Power BI
106

Unable to solve the Average days issue using DAX. Here is the example.

Average date between two dates

…
Troubleshooting Solution

Power BI change chart colors where there is a theme

byMurray Brown
1

Hi

In Power BI I have chosen a Theme for my reports. If I want to change the colors of individual

…
Troubleshooting Solution

Power BI Issue with Slicer

byMurray Brown
1

Hi

In Power BI I have a slicer shown in the image below. When I make selections it is not clear which

…
Troubleshooting Solution

Power BI - Select Daye range

byMurray Brown
1

Hi

In Power BI is it possible to select a date range using a from and to date selector?

Thanks

Troubleshooting Solution

Power BI - help with line chart

byMurray Brown
2

Hi

In the following Power BI report I am trying to to show different lines for each Binder in the

…
Troubleshooting Solution

Power BI report - export pivoted data to Excel

byMurray Brown
2

Hi

In my Power BI report shown below I want the user to be able to export the data to Excel in it's

…
Troubleshooting Solution

Power BI - Angle legend items and order dates

byMurray Brown
2

Hi

In the Power BI report below. How do I angle the legend items so that they fit properly. Maybe 45

…
Article
Decarbonisation

Decarbonisation – The environmental impact of your I.T.

byAdrian McGarry
1
"Carbon neutral" is just the start! Let's take a look into decarbonisation as we set up a blueprint for the future.
Troubleshooting Solution

Retrieve a years' data 7 days at a time - M Language

byuserTester
5

My data source retrieval requires a date range of 7 days, but I need to retrieve all data for the

…
Troubleshooting Solution

Power BI convert whole report or just grid to black background

byMurray Brown
1

Hi

I am trying to convert the Power BI report to a black or dark background with light text in the

…
Troubleshooting Solution

Power BI The table uses direct query and cannot be shown

byMurray Brown
1

Hi

In Power BI I see "The table uses direct query and cannot be shown". Is there no way to model my

…
Troubleshooting Solution

Creating dataset for everyday instead monthly with calculations.

byDaryl Chisholm
4

I have a dataset that is projections for items with two categories.  Each item has a projection for

…
Troubleshooting Solution

Power BI - Direct Query vs Import of SQL

byMurray Brown
2

Hi

In Power BI Desktop I want to create reports that connect to an Azure SQL database. If I do a

…
Troubleshooting Solution

Power BI Use a Variable in Measures

byMurray Brown
1

In Power BI I am creating the following measures around a field called Gross_Premium. I have to then

…

Do more with Experts Exchange.


Get Answers

Join a Group Discussion

Collaborate

Monitor your Site

Explore solutions and more