A Fine Slice Of SQL Server
Adam Saxton shows how to embed a Power BI dashboard into a separate application:
In this video, I go over the embed a dashboard sample and walk you through how to actually embed a dashboard into your application. This uses a combination of the Power BI REST APIs and the JavaScript API.
The video is just over 13 minutes long, but walks you through the process step by step.
Comments closedDevin Knight continues his Power BI custom visuals series:
In this module you will learn how to use the Long Text Viewer Power BI Custom Visual. The Long Text Viewer visual helps in displaying longer text fields that you have in your dataset.
I am happy that this exists, but not sure how frequently I would use it.
Comments closedChris Webb shows that you can copy a query and paste into Notepad to get the M code for that query:
Two years ago I blogged about a method to export all the M code for all of your queries in Power Query using the Send A Frown button – useful if you need the code for documentation purposes. This trick doesn’t work with Power BI Desktop, unfortunately, but the good news is that there’s a better way to do this now in Power Query and Power BI Desktop using copy/paste. It’s pretty simple really: when you copy a query from the Power Query or Power BI Desktop Query Editor you can not only paste the query to another Query Editor (pasting from Power Query to Power BI and vice versa works too) but you can also paste the query to a text editor like Notepad and get the M code for the query.
Read on for more.
Comments closedDevin Knight continues his Power BI custom visuals series with the waffle chart:
In this module you will learn how to use the Waffle Chart Power BI Custom Visual. The Waffle Chart visual is most useful for presenting a percentage of data. This chart is a great option to choose over other visuals like Pie Charts, which are not great at showing proportions of data.
Waffle charts are infographic-friendly visuals; they’re easy to read and as long as you don’t have too many categories, easy to compare.
Comments closedDevin Knight continues his Power BI custom visuals series with the Mekko Chart:
This visual is a mixture between a 100% stacked column chart and a 100% stacked bar chart.
The width of a column is proportional to the total value of the column.
With a relatively small number of groups for both columns and rows, this is a good way of getting a feel for relative weights across two dimensions.
Comments closedNicolo Grando talks about a couple of Power BI features, conditional formatting and Quick Calc:
If you select a text column you can:
- Show only the first attribute
- show only the last attribute
- Count the attribute
- Distinct count the attribute
If you select a numeric column you can:
Sum of value
find the minimum or maximum value
Average the value of column
standard deviation of value
Count the value
Distinct count of value
Variance fo value
Median of value
The screenshots are in Italian, but it’s pretty easy to get the context behind them.
Comments closedKoen Verbeeck has a follow-up post regarding dynamic shape changing in Power BI:
Yesterday I published the blog post Dynamically Changing Shapes in Power BI, which seemed to be quite popular in social media. It showed a lot of people were struggling with this issue and that some people had also found (alternative) solutions for it. In the comments of that blog post, you can find a solution proposed by Jason Thomas (blog | twitter). Jason has quite the Power BI & SSRS knowledge and he has found a cool trick to solve our changing images problem. In this blog post, I’m going to explain the solution step-by-step.
Click through to see the solution.
Comments closedRob Collie uses DAX to find disproportionate sentiment on a per-group basis:
My wife loves to travel AND she loves data, so it’s no surprise that she showed me the infographic in question.
“Oh come on, California residents don’t visit the Philippines more often than any other country.” That was my first reaction. (Mexico is the overwhelming #1 destination, basically for every state… because Cancun. And because there are so many Mexican-Americans).
“Ah… but California residents DO visit the Philippines disproportionately more often than they ‘should,’ according to national averages!” That was my dawning second realization (and confirmed by the fine print of the Orbitz article, even though the article’s title suggests otherwise.)
So, how do we do that in DAX? Pretty simply, actually.
I’m mentally working out whether this could be useful in anomaly detection.
Comments closedAdam Saxton has a quick video demonstrating a dual KPI custom visual:
The Dual KPI efficiently visualizes two measures over time. It shows their trend based on a joint timeline, while absolute values may use different scales, for example Profit and Market share or Sales and Profit.
Each KPI can be visualized as line chart or area chart. The visual has dynamic behavior and can show historical value and the change from the latest value when you hover over it. It also has small icons and labels to convey KPI definitions and alerts about data freshness.
I looks cool, but I dunno; my philosophy is that man cannot serve two KPIs.
Comments closedDevin Knight continues his Power BI custom visuals series:
In this module you will learn how to use the Gap Analysis Power BI Custom Visual. The Gap Analysis visual is used to analyze the difference between two different groups of data you have. For example, you might use it to analyze the gap between two answers people gave in survey response data.
I like the gap analysis visual; it works well as a cross-category comparison visual, giving you an idea of the relative importance of each category as well as the change from one time period to the next. It’s a good way of fitting two useful pieces of information into the same visual.
Comments closed