DAX Powered URL Parameter will Blow your Mind | Filter a Report from another Report in Power BI

preview_player
Показать описание
URL Parameter is very useful in Power BI. and when we provide it more Power by utilizing DAX, we can create amazing Power BI solutions. where we can filter a report from another report even if they are built on top of different datasets.
In This Video we will see, how a DAX powered URL parameter can filter any other report having same fields.

Get Help into Questions Related to #powerbi, #dax, #powerquery Power BI #datamodeling, #analysisservices and #powerbiservice and #microsoftfabric

Follow us on LinkedIn
@PowerBIHelpline
Рекомендации по теме
Комментарии
Автор

This is underrated power bi channel on YouTube...

Thanks brother... Keep it up...
Your teaching is awesome

perfectionist
Автор

Very helpful...I have a similar use case....

I have a matrix visual with 6 to 7 levels, but the hyperlink enable from level 4 i.e SubCategory till level 7 dynamically....
1. Level 1 - Ship Mode
2. Level 2 - Region
3. Level 3 - Category
4. Level 4 - SubCategory
5. Level 5 - Product
6. Level 6 - Supplier
7. Level 7 - State

Here how it should work...as I mentioned the hyperlink should enable on the metric/measure from level 4 - SubCategory in which hyperlink should pass all the values of current level as well as previous levels (SubCategory, Category, Region and Ship Mode)
Next level i.e Product in which hyperlink should pass all the values of current level i.e Product as well as previous levels (SubCategory, Category, Region and Ship Mode)
so tried with HASONEVALUE, but it's not working as

Could you please make video on the same ASAP as I have some requirement...it will be a great help and hope it will help others...

Thanks in advance....

PavanCh-qu
Автор

This technique would be great for drillthroughs across reports.

learntech
Автор

can you explain how slicer selected values are getting passed as I don't see SELECTEDVALUE function etc?

LearnShare
Автор

Explain the dax functions that is used in line No 4 and 12.Never came across dax syntax like this, and variable inside another.

BISimplifier
Автор

Passing variable, GET method 😊 just know in PBI, thanks

asriyantoryan