Monday, August 21, 2017

Power bi new matrix feature - Update August 2017

You can now natively put measures on rows in a matrix in both Power BI Desktop and PowerBI.com.
This is accomplished via a new formatting option for the matrix.
Here is  a table with years on columns and measures in values (and nothing on rows).
Add three measures: Sales Amount, Total Cost, Gross Margin.

 
Initially, the matrix puts the measures across the columns

 
Change that in the formatting options.

Find the Values section on the formatting pane and look for Show On rows.
Toggle that switch to On.
That  gives you the three values on rows.



No comments:

Post a Comment

if you have any doubts, please tell me

More Than One Form Was Opened at Once for the Lookup Control

In Dynamics 365 for Finance and Operations, when subscribing to a lookup event to modify an existing lookup on a form control, you must...