If you want to become an Power BI expert, check out all our helpful tutorials on Microsoft Power BI. All the tutorials are written by experts and followed steps properly and written with screenshots. You can email us if you still have questions for us.
You can change data source in Power BI Desktop in a few clicks: go to Home > Transform data > Data source settings, select the source, choose Change Source, enter the new file path or server, and apply the changes. Your visuals, measures and relationships stay as they are. A typical case: a Contoso sales … Read more >>>
In Power BI, a slicer is a visual on the report canvas that readers click to filter the page, while a filter lives in the Filters pane and can apply to one visual, one page, or the whole report. Both filter the same data. The difference is where they sit, who uses them, and how … Read more >>>
A Power BI column chart shows one vertical column per category, and the height of each column is its value. To create one, select a column chart in the Visualizations pane, add a category such as Region to X-axis and a number such as Revenue to Y-axis. At Contoso, the sales manager asked me for … Read more >>>
To create a stacked funnel chart in Power BI, use a stacked bar chart instead of the funnel visual. Put your stages on the Y-axis, add one measure per segment to the X-axis, and put a transparent “spacer” measure first so every bar is pushed to the center and the chart takes the shape of … Read more >>>
To use conditional formatting in a Power BI stacked column chart, select the chart, go to Format visual > Visual > Columns > Color and select the fx button. Then choose Rules, Gradient or Field value, and it works whether or not the chart has a legend. At Contoso, the sales manager wanted two things … Read more >>>
To sort a stacked bar chart in Power BI by value, select More options (…) on the visual, point to Sort by, choose the value field, such as Sum of Revenue, and then pick Sort descending or Sort ascending. The bars are then ordered by their total, which is the sum of all segments. At … Read more >>>
Do you want to apply transparency to the Power BI area chart? In this Power BI tutorial, we will see how to apply transparency in Power BI area chart. I have explained a small difference between colors and transparency. To be transparent means to be see-through and invisible, while being colored means to be visible. … Read more >>>
In this Power BI article, I will explain what is a Power BI Waterfall chart and when we can use a waterfall chart in Power BI. Additionally, we will discuss how to create a waterfall chart in Power BI using an Excel sheet as well as a SharePoint list. Power BI Waterfall Chart When to … Read more >>>
A Power BI stacked column chart shows one column per category, split into colored segments that add up to the column’s total. To create one, select Stacked column chart in the Visualizations pane, then add a category to X-axis, a number to Y-axis and a second category to Legend. Last month, the sales manager at … Read more >>>
I have created a Power BI report based on ‘Product Sales Information‘ for one client, utilizing various types of visualizations. On that report, the client instructed me to display the average sales amount of products in the matrix visual. However, by default, the matrix visual displays a sum aggregation of the values, showing the total … Read more >>>
122 copy-paste formulas with real examples, sent straight to your inbox.
Your free Power Automate Expressions Cheat Sheet is on its way. Can't find it in a few minutes? Look in your Promotions or Spam folder.
Sent to