How do I group columns by category in the same pivot table in excel?
Good afternoon guys, what's up? I need some help I'd like to layout the PowerBi "Matrix" in the same way that the "Pivot Table" groups the categories before showing the value, as shown in the photos below. 1. Excel - Pivot Table In the image below we can see that the pivot table first categorizes the values - Volume/Weight and Volume Measure - before grouping by BAT/PMI and JTI 2 - Power BI - Matrix In Power BI, the "Matrix" does just the opposite, first it categorizes BAT/PMI/JTI and then it categorizes the values I would like to know if it is possible to visualize the "Pivot Table" (example of photo 1) in PowerBI with "Matrix"?
Re-order column on matrix visualization
Hi, I have created matrix visualization like below. But, I need to move the latest (W-1,W-2) under each of Freq and SLF. Also I need to make it W-1 first and then W-2. Here I attached an example for what visualization I want. Could anyone help me on this case please? Thanks in advance 🙂
How to create power BI visual for matrix table from multiple sheets.
Im new to POWER BI. How to create visual for matrox table? I need to create a dashboard with two bar charts, the first of which will display reports by category. Second, the chart will display the product-based report. However, in order to create an interactive main chart, I need to connect two sheets. If you click the corresponding category in the main chart, the second chart will be based on the first chart's selected category. How to do that?  
