Create Visual/Custom Visual for Power BI: Different Approaches

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[…]

DAX : Inventory or Stock Valuation using FIFO

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[…]

Fun with DAX – Compressing Numeric Sequences to Text

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[…]

New Series of Time Series: Power BI Custom Visual (Part 6)

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)[…]

New Series of Time Series: Part 2 (Exponential Smoothing)

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)[…]

Identifying Number of Cluster in K-mean Algorithm in Power BI: Part 7

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[…]

Variable Width Column  Chart, writing R codes inside Power BI: Part 4

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[…]