cancel
Showing results for 
Search instead for 
Did you mean: 

Find articles, guides, information and community news

Most Recent
Greg_Deckler
Super User
Super User

The new EVALUATEANDLOG DAX function is great, but how do you actually use it in conjunction with SQL Profiler. This articles shows how and also demonstrates how to configure SQL Profiler as an external tool for Power BI Desktop.

Read more...

amitchandak
Super User
Super User

If you use power bi direct query, you can define a date table at the source or in power bi. You can create a date table in Power BI. The table created in Power BI is in import mode. Power BI will enable mixed-mode queries.

Read more...

RicoZhou
Community Support
Community Support

This is an article about how to sort multiple columns by dax.

Read more...

cfriss
Regular Visitor

Continuation of Dynamic Paretos - getting the counts and building the visuals.

Read more...

cfriss
Regular Visitor

Easily build dynamic pareto charts, and even more importantly, dynamically show which percentage of a category accounts for the majority of activities. Using the pareto principle, easily build an interactive parety style dashboard. 

Read more...

yingyinr
Community Support
Community Support

Apply AND logic in the slicer

Read more...

Fowmy
Super User
Super User

In this 3 minute post, you'll learn how to modify the custom theme file in Power BI to toggle the visibility of the calendar icon in the Date Slicer. This feature was introduced back in the March 2022 PBI Update, but it lacks the GUI option to turn on or off the calendar icon.

Read more...

RicoZhou
Community Support
Community Support

This is an article about how to do dynamic group counting in Power BI.

Read more...

Fowmy
Super User
Super User

Solving a Power Query challenge to find out the the  no of wins by soccer teams

Read more...

Shaurya
Memorable Member
Memorable Member

The world that we live in is filled by an infinite number of sensors that continuously collect data of all sorts. Among several other categories of data, these devices read a huge of amount of telemetry data which can be analysed thoroughly and put to good use. Azure IoT Central is a ready to use platform that allows us to connect to multiple IoT Devices and monitor the data that we receive from them. It can be used by large enterprises to analyse data at scale. Alternatively, it can be used by individuals who are looking for a new report idea.

 

Once such idea is connecting our mobile phones to IoT Central and then analysing the telemetry data received from it by exporting it into Power BI. Here's a quick walkthrough of the steps that you'll need to perform to export the required data into a Power BI Dataset:

 

  1. Start with https://apps.azureiotcentral.com/home
  2. Build a custom app or use a template.
  3. Add the Devices.
  4. Check the data that is flowing in from the Android Device.
  5. Go to Azure portal and create an Event Hub. Start by creating a Namespace first. Create an Event Hub within it.
  6. Give access to the event hub for listening to messages and get the connection string.
  7. Configure Destination in IoT Central by choosing the event hub you just created.
  8. Configure the Export.
  9. Check the status of the Export.
  10. Create a Stream Job in Azure.
  11. Set the Event Hub as input and a Power BI workspace as output for the job.
  12. Modify the query to get data in the required format.
  13. Start the Stream Job.
  14. A dataset will automatically be created in the selected Power BI workspace.

 

Once you have the Dataset in your workspace, you can use that as a source in your Power BI Report and analyse your phone’s GPS coordinates, whether it was picked up by someone and moved and a lot more by looking at the telemetry data.

Fowmy
Super User
Super User

A simple Power BI Tip on how to sort a column with duplicates by another column containg different granularity.

Read more...

Greg_Deckler
Super User
Super User

What if when Power BI was released all those years ago that it defaulted to table and matrix totals simply summing the rows? Let's explore this alternate reality and how you would handle displaying an alternate summary of information in a table or matrix.

Read more...

Kumail
Post Prodigy
Post Prodigy

Power BI offers a good set of in-built visuals which you can access and use from the Visualization pane in Power BI Desktop.

Read more...

Fowmy
Super User
Super User

Using Power Query ETL, here's a method I implemented for transforming multiple columns in a single step based on another column. In my most recent Power BI project on Financial Reporting, I had to deal with this challenge. In Power Query, using just the GUI may take more steps and take longer to achieve the desired result. The results can be obtained quickly and efficiently by applying a bit of "M" coding.

Read more...

RicoZhou
Community Support
Community Support

This is an article about how to get the value in a column based on condition of another column in Power Query.

Read more...

Helpful resources

Join Blog
Interested in blogging for the community? Let us know.