cancel
Showing results for
Did you mean:

Earn a 50% discount on the DP-600 certification exam by completing the Fabric 30 Days to Learn It challenge.

Frequent Visitor

## Use DAX values in Row

Hi, I have a below raw data table.

 Date S.No Category Name Input1 Input Value1 Input2 Input Value2 Target Achieved Breached Sunday, 1 October, 2023 5 Category5 Name5 Text5 5 Text5 5 5 5 5 Sunday, 1 October, 2023 4 Category4 Name4 Text4 4 Text4 4 4 4 4 Sunday, 1 October, 2023 3 Category3 Name3 Text3 3 Text3 3 3 3 3 Sunday, 1 October, 2023 2 Category2 Name2 Text2 2 Text2 2 2 2 2 Sunday, 1 October, 2023 1 Category1 Name1 Text1 1 Text1 1 1 1 1 Friday, 1 September, 2023 5 Category5 Name5 Text5 5 Text5 5 5 5 5 Friday, 1 September, 2023 4 Category4 Name4 Text4 4 Text4 4 4 4 4 Friday, 1 September, 2023 3 Category3 Name3 Text3 3 Text3 3 3 3 3 Friday, 1 September, 2023 2 Category2 Name2 Text2 2 Text2 2 2 2 2 Friday, 1 September, 2023 1 Category1 Name1 Text1 1 Text1 1 1 1 1

In the above Raw data, the below colums are calculated as DAX.

Input1
Input2
Target
Achieved
Breached

When I try to plot this table in a Matrix visual, I am getting the visual as below:

I couldn't plot the DAX values in Row section, hence the the above visual is in the order Input1, Input2, and the respective values

My requirement should be as below with one change, I want the Date in Column.

@amitchandak , @Greg_Deckler @lbendlin , @DesktopOwl @Goodlytics4U @help Ahmedx @Ahmedx @lbendlin : Is there any way to acheive this ??

7 REPLIES 7
Resident Rockstar

When I plot the data in a table, I am getting it as your expected output

Frequent Visitor

Hi, I am also getting the same visual, but below is my requirement in Matrix Visual as you mentioned @Thejeswar

1, Date in Column

2, In the order of Input1, Input1 Value, Input2, Input2 Value
3, Input1 Value & Input2 Value are DAXs. Hence it can't be placed in Rows.

I don't think it is possible, Anyway thank you!

Super User

Dax measures cannot be place in rows that is correct.

If the information is sensitive please share it trough private message.

Regards

Miguel Félix

Proud to be a Super User!

Check out my blog: Power BI em Português

Super User

@gssarathkumar
If you want exactly this table

this is possible via table visual

Thanks

Don't forget to give thumbs up and accept this as a solution if it helped you!!!
Frequent Visitor

Yeah, I should be able to switch the Date either on Rows / Columns, but my requirement is to visualize the data in the mentioned order. I tried and found it is not a possible solution.

Super User

The mentioned order on what visualization? On a table?

Regards

Miguel Félix

Proud to be a Super User!

Check out my blog: Power BI em Português

Super User

Being the date a column you should be abble to use it in rows or columns, but looking at your final result have you tried creating a Table visualization instead of a Matrix?

Regards

Miguel Félix

Proud to be a Super User!

Check out my blog: Power BI em Português

Announcements

#### Fabric certifications survey

Certification feedback opportunity for the community.

#### Power BI Monthly Update - April 2024

Check out the April 2024 Power BI update to learn about new features.

#### Fabric Community Update - April 2024

Find out what's new and trending in the Fabric Community.

Top Solution Authors
Top Kudoed Authors