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]

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]

Today’s topics including: [Read More]

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]

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]