The ultimate Microsoft Fabric, Power BI, Azure AI, and SQL learning event! Join us in Stockholm, Sweden from September 24-27, 2024.
2-for-1 sale on June 20 only!
Find everything you need to get certified on Fabric—skills challenges, live sessions, exam prep, role guidance, and more. Get started
Actually, in matrix table, I used slicer to filter.When I click certain filter ,its corresponding values(i.e)column 1 value want to be displayed, if selecting all in filter want a value which is apart (i.e)column 2 value want to be display
Solved! Go to Solution.
Hi @Uma_Dhandpani ,
You are referring to dynamically changing column displayed by slicer selection, please check below similar posts:
Hi @Uma_Dhandpani ,
It seems your description is a little bit different with above post, I've created a pbix based on your question:
Measure = IF ( HASONEVALUE ( 'Table 2'[Currency Mode] ), IF ( SELECTEDVALUE ( 'Table'[Attribute] ) = "BaseAmount", CALCULATE ( MAX ( 'Table'[Value] ), FILTER ( 'Table', [Attribute] = "BaseAmount" ) ) ), IF ( SELECTEDVALUE ( 'Table'[Attribute] ) = "Total amount", CALCULATE ( MAX ( 'Table'[Value] ), FILTER ( 'Table', [Attribute] = "Total amount" ) ) ) )
pbix attached.
The first image denotes the field I have and second , the report to be .Default, it should display the Total_Amount value, when I click on the filter (i.e) dollar/euro/rupee, it should display the Base_Amount value
Hi @Uma_Dhandpani ,
It seems your description is a little bit different with above post, I've created a pbix based on your question:
Measure = IF ( HASONEVALUE ( 'Table 2'[Currency Mode] ), IF ( SELECTEDVALUE ( 'Table'[Attribute] ) = "BaseAmount", CALCULATE ( MAX ( 'Table'[Value] ), FILTER ( 'Table', [Attribute] = "BaseAmount" ) ) ), IF ( SELECTEDVALUE ( 'Table'[Attribute] ) = "Total amount", CALCULATE ( MAX ( 'Table'[Value] ), FILTER ( 'Table', [Attribute] = "Total amount" ) ) ) )
pbix attached.
Hi @Uma_Dhandpani ,
You are referring to dynamically changing column displayed by slicer selection, please check below similar posts:
Hi @Uma_Dhandpani ,
Could you please show more details with expected data?
Join the community in Stockholm for expert Microsoft Fabric learning including a very exciting keynote from Arun Ulag, Corporate Vice President, Azure Data.
Check out the June 2024 Power BI update to learn about new features.
User | Count |
---|---|
99 | |
93 | |
82 | |
64 | |
58 |
User | Count |
---|---|
248 | |
123 | |
112 | |
79 | |
78 |