There is always a need to extend the usage of visuals in Power BI. There are multi ways to do it first using First Option: Using Standard Panel Easy to use and available all the time all tested and reliable Read more about Create Visual/Custom Visual for Power BI: Different Approaches[…]
All source files for this article can be downloaded here : A good friend and member of my local Power BI User Group contacted me recently to ask if I might help with a problem he trying to solve in DAX. He was keen to track the value of items purchased over time in chronological Read more about DAX : Inventory or Stock Valuation using FIFO[…]
To follow in the spirit of some of my recent blogs, I thought I would have a look to see how feasible it might be to build a Tic Tac Toe game using just DAX and Power BI. I get pretty close and will detail my approach here in this article. For starters, here is Read more about Fun with DAX – Tic Tac Toe[…]
A recent post on the Power BI community website asked if it was possible to compress a group of numbers into text that described the sequential ranges contained within the numbers. This might be a group of values such as 1, 2, 3, 4, 7, 8, 9, 12, 13: (note there are gaps) with the Read more about Fun with DAX – Compressing Numeric Sequences to Text[…]
In the last post, I have explained how to do time series forecast using “Exponential Smoothing” approach in Power BI. I start to explain the main parameters that we need to set up. The main concepts behind of most of these parameters have been explained in previous posts (Post 4, Post 3, Post 2, and Read more about New Series of Time Series: Power BI Custom Visual (Part 6)[…]
In the last post , I have explained the main concepts behind the timeseries. In this post, I am going to show how we can forecast for some periods. In the last post, I have mentioned that there is a possibility to have “seasonality” “Trend” and errors (residual) in one dataset: Seasonality+Trend+Residual we call it as Read more about New Series of Time Series: Part 2 (Exponential Smoothing)[…]
I have explained the main concept behind the Clustering algorithm in Post 5 and also I have explained how to do cluster analysis in Power BI in Part 6. In this post, I will explain how identify the best number of cluster for doing cluster analysis by looking on the “elbow chart” K-Mean clusters the data Read more about Identifying Number of Cluster in K-mean Algorithm in Power BI: Part 7[…]
In the part 1, I have explained how to use R visualization inside Power BI. In the second part the process of visualization of five dimension in a single chart has been presented in Part 2, and finally in the part 3 the map visualization with embedded chart has been presented. In current post and next ones I Read more about Variable Width Column Chart, writing R codes inside Power BI: Part 4[…]