Forum Discussion

janani80's avatar
janani80
Frequent Visitor
1 year ago
Solved

Matrix Report- Dynamic column headers

I am pretty new to powerbi and I am required to create a matrix visual based on the table below. Based on slicer selection the header should dynamically change.    Year Product No of Units man...
Need Help
  • janani80's avatar
    janani80
    1 year ago

    Thanks hnguy71.. It worked now.. And sorry to disturb you on a weekend.

janani80's avatar
janani80
Frequent Visitor
1 year ago

Hi hnguy71

Thanks for the calculations, however when I tried the same measure for my report(the data is different) I did not get the desired output. Hence I used the same data which I shared with you and the same steps but still I did not get the desired output. I had added the product in the rows, Year in column and the Measure(Metric_Analysis) in the value section. Below is the printscreen for your reference. Am I doing some step wrong?

 

Thanks

Janani80

  • janani80's avatar
    janani80
    Frequent Visitor
    1 year ago

    Thanks hnguy71.. It worked now.. And sorry to disturb you on a weekend.