Forum Discussion

shashankp1's avatar
shashankp1
Frequent Visitor
5 years ago

Static matrix Column Header (without slicer impact)

Hi Team, My Date table is joined with Sales Table.Sales Table contains one dimension field which is also slicer for the report page.I have created matrix with Quarter(Column Header from Date table) ...
Need Help
Anonymous's avatar
Anonymous
Not applicable
5 years ago

Hi shashankp1 ,

According to my understand, you want to keep the row header in Matrix but display dynamic values based on slicer ,right?

Since there is a relationship between Sales and Date tables , you should create a new table  with Quarter columnfor slicer. Then use the following formula:

Measure =
VAR _sele =
    SELECTEDVALUE ( Sales[ID] )
VAR _quarter =
    CALCULATE ( MAX ( 'Date'[Quarter] ), FILTER ( 'Date', 'Date'[ID] = _sele ) )
RETURN
    IF ( MAX ( 'forSlicer'[Quarter] ) = _quarter, SUM ( Sales[Amount] ), BLANK () )

 

Here is the pbix file.


Did I answer your question ? Please mark my reply as solution. Thank you very much.
If not, please upload some insensitive data samples and expected output.

 

Best Regards,
Eyelyn Qin

Anonymous's avatar
Anonymous
Not applicable
4 years ago

Hi,

 

Could you please post a new pbix file? the old one is not working anymore. Thank you