Do you want show values on Rows on Power BI Matrix? Do you have requirement to show Headers and values in single line?
If yes, I’m going to show you How to showcase Header and Values on Power BI Matrix with Just a simple option.
You will have a Requirement to show values on rows but when you try to show it in Power BI you will get to see like this even though in placing fields here and there in the shelf
Hmm! How to show Tax Amount and Sales Amount in two rows as you can see in below Image
Here is a Trick…..
Before that
Please don’t forget to share and subscribe AforAnalytic Blog to receive amazing Tableau and Power BI contents like this
Microsoft Power BI has a option in latest release on to enable show row option, You can find it in Formatting Option -> Value Drop down -> Show on Rows
In the Image, it’s turned off, if you want to see the Header and Values in two separate rates, you have to Turn On the Option.
On you Turned On, you will see the rows shifted up right like below Image
Bonus
Are you Interested in Learning one more thing in this Now, Click here to learn Tableau Printing Capabilities.
Conclusion
In August release, you have received this update to Power BI Desktop as a new feature. It will works well in adding new fields to the values shelf.
A for Analytic Providing Data Analytics consulting to Fortune 500 companies to build Business Intelligence solution upon their Multiple Complex Data warehouse by solving problems like this without worry on In-house resources.