question

TianyangJiang-8504 avatar image
0 Votes"
TianyangJiang-8504 asked Ehren answered

How to customize the row and column in the table, and the Axis and Legend in the column chart?

Hi everyone,

I recently have encountered some problems. In order to explain my problem conveniently, I created a demo case. The structure of this table is similar to the structure of my work. Below is a screenshot of this table and the results I have achieved.

87192-question-1.png


87193-question-2.png


87194-question-3.png


87195-question-4.png


87196-question-5.png


As you can see, the table and two-column charts in the screenshot can be achieved now, but the result I really want to achieve is the following two pictures.

87197-my-requirement-6.jpg


87198-my-requirement-7.jpg



In the final table, I want my row to have the Top-2 values of Actual rank among all L2 values (Car and House in this case), and then separate Others as a row, and then create a new row All Other including all values except Top-2 and Others. (In this case, there are Apple, Banana, and Melon)

In the column, I want to show only 4 columns which are Actual 2020(The Actual value in 2020), Actual 2021, Budget 2021, and Forecast 2021.

The two requirements are too hard for me, I tried a lot of functions such as creating a new table, or add some Measures, but I failed. :(

In the two-column charts, I want to show the special value in Axis and Legend (I wrote them in the picture) but I also failed. I don't know which way is the correct one.

power-query-not-supported
question-1.png (28.6 KiB)
question-2.png (4.7 KiB)
question-3.png (64.8 KiB)
question-4.png (72.0 KiB)
question-5.png (71.6 KiB)
my-requirement-7.jpg (137.2 KiB)
5 |1600 characters needed characters left characters exceeded

Up to 10 attachments (including images) can be used with a maximum of 3.0 MiB each and 30.0 MiB total.

1 Answer

Ehren avatar image
0 Votes"
Ehren answered

This sounds like more of a Power BI question than a Power Query one. I'd recommend you post it on the Power BI Community forum.


5 |1600 characters needed characters left characters exceeded

Up to 10 attachments (including images) can be used with a maximum of 3.0 MiB each and 30.0 MiB total.