Eric's Blog
  • Blog
  • Tags
  • About Me

Ironman's Lab


Perfect this world with BI

Ironman's Lab


Perfect this world with BI

How to Write A Conditional Measure Linked with Slicer

a rolling up model

Posted on June 15, 2018

This blog introduces how to write a conditional measure linked with slicer, which also combines a rolling up model as extra content. The key DAX built-in function is VALUES. [Read More]
Tags: PowerBI Measure DAX Matrix VALUES Slicer

How to Setup Your Own Theme of PowerBI Reports

Tips and Examples of creating JSON File

Posted on May 13, 2018

When you start designing a lot of PowerBI reports, you will meet two questions. Company has a certain color palette for you to use, Or you want to make your own one. The Matrix, Card ,etc. the frequently used visual, you want to make them consistent looking in every report... [Read More]
Tags: PowerBI Theme JSON Color palette

Investment Return Rate Calculation in Power BI

Iteration of Multiplication

Posted on April 29, 2018

Today’s topics including: [Read More]
Tags: PowerBI DAX Iteration PRODUCTX EARLIER INDEX

How to Calculate Percentage of Total in Matrix in Power BI

row and column groups from different tables

Posted on April 20, 2018

This blog simply introduces how to calculate percentage of total in Matrix with row and column groups from different tables in the model. The key DAX built-in function is ALLEXCEPT. [Read More]
Tags: PowerBI SQL DAX Matrix ALLEXCEPT

How to Pass Multiple-Values Parameters to SQL Statement

to Design a Dynamic Power BI Report

Posted on November 12, 2017

There are many articles about How to pass parameter to SQL statement in PowerBI, but none of them address my issues, so I crack it and decide to write this article to document it. If you have better method, please do let me know! [Read More]
Tags: Power BI SQL Parameter
  • ← Newer Posts
  • Older Posts →
  • Email me
  • GitHub
  • LinkedIn

Eric Dong  •  2022  •  FunBIWorld.com

Theme by beautiful-jekyll