Every visualization in Power BI has a Visual Level Filters section that by default includes all the columns and measures included in the visualization. This section can include additional filters over columns and measures. The Visual Level Filters section is the only one accepting a measure as a filter, whereas Page Level Filters and Report Read More
Category: Power BI
How to Use Date vs Date Hierarchy in Power BI
By Steve Young As with most data analysis tasks, working with time can be the most challenging detail to get correct. Power BI has built-in functionality that will display a drillable hierarchy of year, quarter, month and days when a column, formatted as a date, is dropped onto a visualization. This feature can be handy Read More
Understanding Difference Between Calculated Columns and Measures in Power BI
Calculated columns When you create a data model in Power Pivot for Excel, Analysis Services Tabular, or Power BI Desktop, you can extend a table by creating new columns. The content of the columns is defined by a DAX expression evaluated row by row. The user interface is different depending on the tools you use. Read More
How to Change Power BI Data Source From MS SQL Server to Excel
Changing Power BI data source from MS SQL Server to Excel for Power BI file
How to Connect to a Google BigQuery Database in Power BI Desktop
In Power BI Desktop, you can connect to a Google BigQuery database and use the underlying data just like any other data source in Power BI Desktop. Connect to Google BigQuery To connect to a Google BigQuery database select Get Data from the Home ribbon in Power BI Desktop. Select Database from the categories on the left, and you see Google BigQuery. In the Google BigQuery window that Read More
How to Change Data Source From Excel to MS SQL Server Database in Power BI
We will change the data source by using some basic M language script. The reason we need to do this by using M language is that Power BI data source settings does not provide us an option to change the source directly as shown below. Now to change the via M script we will do Read More