Show measures in first place of rows

[viswaaa]

Hi ALl,

I have a matrix chart and I kept country in rows ,year ij columns and measure values in values and move them to rows as per my requirement.
But I need to get measure values as before country.

Please suggest how to get this

[Anonymous]

Hi

Please do below steps to get required results.

1. Create 1 Column Table  with sales & profit text in column below is formula.

Sales_Profit_Table =

               {

                      ("Sales"),

                      ("Profit")

               }

2. Create Table using below Dax Formula.

Test_Tbl =

ADDCOLUMNS(

            CROSSJOIN(Sales_Profit_Table,Sales),

            "SUM",IF(Sales_Profit_Table[Value]="Sales",CALCULATE([Total Sales]),CALCULATE([Total Profits])))

2. Then Put columns from this Test_Tbl into Matrix Visual

    Rows :-  Values, Country

    Columns :- Year

    Values :- Sales measure

4) Select Matrix Visual & Goto Row Header. Stepped Layout to OFF

Thanks & Regards

Pravin  Angane

[mh2587]

Just enable the show on rows option under format tab

[Uzi2019]

Hi @viswaaa 

Please share the sample data...

[viswaaa]

Here it is

Country	Year	Sales	Profit
USA	2017	100	20
USA	2018	200	30
UK	2017	300	20
UK	2018	400	50

[Bibiano_Geraldo]

Hi @viswaaa ,

Can you share the realy picture of your Matrix and sample data?

[viswaaa]

Hi @Bibiano_Geraldo 

Here it is

Sample Data :

Country	Year	Sales	Profit
USA	2017	100	20
USA	2018	200	30
UK	2017	300	20
UK	2018	400	50

[Bibiano_Geraldo]

Hi, 

I just placed the field as you done, and my output look like this:

[viswaaa]

Hi @Bibiano_Geraldo ,

You need to go to formatting and select switch values to rows option as below.

[DataNinja777]

Hi @viswaaa ,

You can achieve your desired output by selecting "Tabular" instead of "Compact" in the Layout and style presets section of the Visualizations pane in your Matrix visual.

Best regards,

[viswaaa]

Hi @DataNinja777 ,

But I need to get my measures in first place of rows.

like below

For now I am getting country in first place