The ultimate Fabric, Power BI, SQL, and AI community-led learning event. Save €200 with code FABCOMM.
Get registeredEnhance your career with this limited time 50% discount on Fabric and Power BI exams. Ends August 31st. Request your voucher.
Hello,
I have created a table of measures.
Below is the table obtained:
Each column is presented with the following (the measurements are identical, only what is in bold changes)!:
The resulting graph:
I had done the same thing in Excel, the table is identical to the one in Power BI but the graph is the one below much more telling:
These work well. With the exception of:
- It doesn't show up in Power Query
- The inverse graph X and Y.
How to make the chart look like the one obtained on Excel.
How to make the sum of each column, lines 1 to 6 and display it on the "Total" row.
Thank you for your feedback.
Kind regards.
Hi @Bob639 ,
Based on the description, Power Query is primarily used for data transformation and shaping, and it does not execute DAX measures.
Then, invert the X and Y axis options.
Best Regards,
Wisdom Wu
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
Hello, Thank you for your feedback. Ok for Power Query, for the graph it just inverts the Y scale (below)
It's not what I expect, see initial graph.
Kind regards.
User | Count |
---|---|
27 | |
12 | |
8 | |
8 | |
5 |
User | Count |
---|---|
31 | |
15 | |
12 | |
11 | |
7 |