Forum Discussion
Table/matrix with date in column
Hi,
Isn't possible to create a matix with dates/months as columns and various measures as rows?
Like this:
Thank you!
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 _ kalyjIf this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
5 Replies
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 section2) 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
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.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://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!
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
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 _ kalyjIf this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
