Table/matrix with date in column

[Kikihoffmann]

Hi,

Isn't possible to create a matix with dates/months as columns and various measures as rows?

Like this:

Thank you!

[v-yanjiang-msft · Accepted solution]

Hi @Kikihoffmann ,

According to your description, use various measures as rows can just follow @sevenhills 's solution. 

For your second question, here's my solution.

1.Bold only works for all the measures instead of a particular measure. In the visual formatting pane>Values.

2.For example you want to color the Sales measure to red, in the Cell elements tab, select Sales in the Series option, then turn on the Font color option.

Click the fx button, in the dialoge, select Gradient format style, select red color both in the lowest value and highest value.

Get the result:

I attach my sample below for your reference.

Best Regards,
Community Support Team _ kalyj

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

[Kikihoffmann]

Thank you so much! 

A last question in this - is it possible to highlight (color/bold) some measures? 

E.g. if I want sales and total costs to be bold/red

[sevenhills]

Yes it is possible.

1) Build a matrix,

      Say, with Month-YY on columns
             and All the measures you want as usual i.e. in the values section

2) change these settings

          Go to format your visual in the visualizations

          search for "switch values to rows"

          Turn them on

You will be seeing the above layout

[Agucho76]

Hi @sevenhills  how do you get the Date columns to be properly sorted (chronologically)?

I did the same, but I can't find a way to sort the columns properly, it only allows me to sort them by the measures values.

It does not respect the year nor quarter nor month order of the columns. It sorts them by Revenues.

BTW, my dates table columns (month name, quarter name, and year) are properly sorted.

[sevenhills]

Tip: For any column that needs the custom sort i.e., you don't want default sort, you have to do these steps.

Steps:

* Select the column that you want to apply the custom sort

* Use the Column tools menu

* Select the sort by column and chose the custom right column order.

* If you dont have the custom right column order, create that one before doing the above steps and you can make this as hidden column, so the user wont see.

* Silly tip, but in rare cases works for few: Duplicate the column of Date and format as Month Year and use it. Rare I said, say, the data contains only first or last date of your month and when you format and use this ony it works. (you dont need sort by)

Please go through this links: 

https://learn.microsoft.com/en-us/power-bi/create-reports/desktop-sort-by-column?tabs=powerbi-deskto... 

https://radacad.com/sort-column-name-in-power-query-via-m-code

https://radacad.com/sort-a-column-with-a-custom-order-in-power-bi 

https://www.biinsight.com/quick-tips-how-to-sort-matrix-by-column-in-descending-order/

https://www.youtube.com/watch?v=KK1zu4MBb-c

Hope this helps!