Showing results for 
Search instead for 
Did you mean: 

Fabric is Generally Available. Browse Fabric Presentations. Work towards your Fabric certification with the Cloud Skills Challenge.

Find articles, guides, information and community news

Most Recent
Resident Rockstar
Resident Rockstar

Recently, I ran into a case where the customer required a filter on a multivalued column. However, he wanted to be able to slice based on a single value rather than the combinations of values. The solution we implemented was leveraging Power Query rather than DAX and enabled the customer to slice the data based on any occurrence in the multivalued column. This approach also makes it possible to filter in multiple columns using a single slicer!


Super User
Super User

Power BI Time Intelligence functions provide a powerful way to get different types of time periods and time comparisons. Some of these are MTD, PMTD, PYMTD, MOM, MOYM, QTD, LQTD, QOQ, YTD, LYTD YOY etc. But dealing with a non-standard period can be a bit difficult, especially when months are not the standard months. In this article, we try to take on a case of non-standard periods (months).


Helpful resources

Join Blog
Interested in blogging for the community? Let us know.