Why there is no date hierarchy for the date field

Use Power BI Rest API to export the Power BI Report in PDF format

Scenario: Microsoft 365 usage analytics provides a dashboard in Power BI that offers insights into how users adopt and use Microsoft 365. We can find and use it in Power BI Service apps. But if you still want to get personalized or deeper insights, how will you connect the data model to create a report in Power BI Desktop?

For some Power BI users, it is quite simple to calculate the difference between two rows by using DAX. And this article will provide you with two solutions about how to implement that in Power Query.

Scenario: 

Usually, we can forecast values and return a line chart by using R visual in Power BI. But since it can only return image, how can we return the values as a table? And how can we use these values in the subsequent analysis?

This is a blog about how to merge rows of each category into one row by removing all blank contents

Using Python to get data from a CSV file of a web source

Scenario:

Suppose I have many columns which both column names and fields look untidy.  I want to do some transformations for them in batches. For example, replace multiple spaces as single space and uppercase each first character of word so that the table would look neater.

This is a blog about the Anchor Time in Relative Time Filter and Slicer.

Dual Y axis values in one grouped column chart

Scenario: 

I would like to get only one max value for each student ID. For example, a company needs to examine each person's attendance and identify the arrival time for being late monthly, but for the clarity of the report, it is required that if there is a duplication of the arrival time for being late, only one is identified.

Another example is a sales company that needs to mark the maximum monthly sales of each salesperson on the sales sheet and display the data during meetings. At this time, the maximum sales are duplicated, and if they are all marked, it will affect the beauty of the whole report, so only one of the duplicated maximum values should be randomly marked.

This is a blog about the steps between python process and M engine drops leading zeros.

Factors that cause Drill through feature not work