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]
How to Setup Your Own Theme of PowerBI Reports
Tips and Examples of creating JSON File
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]
Investment Return Rate Calculation in Power BI
Iteration of Multiplication
Today’s topics including:
[Read More]
How to Calculate Percentage of Total in Matrix in Power BI
row and column groups from different tables
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]
How to Pass Multiple-Values Parameters to SQL Statement
to Design a Dynamic Power BI Report
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]