Seeking an ideal Visual to replace current "Line and Column Stacked Column chart"

[F_Reh]

Hi,

I have a Line and Column Stacked Column chart which is displaying data as follows:

As you appreciate the data displayed appears disproportionate, and there is a large proportion of very low values which appears almost like a horizontal line.

Other than a Matrix - can I request for any idea for a more wiser visual ?

Appreciatively

[F_Reh]

I have amended the measure so that '0' is no longer added to null-figured categories which now allows the Logarthmic Scale Feature to be enabled. However, I feel the lower values still graphically appear like a "horizontal straight line".

[F_Reh]

Actually, the Logarthmic Scale feature is greyed out of my graph....I tried to follow this solution on the following page (by changing the Min value on the Y-axis to 0.001 but it failed to enable it):

Logarithmic scale greyed out - Microsoft Fabric Community

But even so, I don't deeem that one as a suitable solution as i do have a solid '0' figure for one of the categories on the X-Axis.

[Anonymous]

Hi,@F_Reh .Thank you for your reply.
The suggestions you have made are valid.

In Power BI, the logarithmic scale will not work if there are values less than or equal to 0 in the data. This is because the logarithmic scale cannot handle non-positive numbers.

The usual solution is to create a new measure (Measure) and work with data that is less than or equal to zero. You can either change these values to positive numbers close to 0, or display them as blank. It's important to note that using an IF judgment to change these values actually only affects how they are displayed, and does not change the actual value of the underlying data. This means that the original data will still be involved in the calculation of the metric values.

The key to this approach is understanding that Power BI's calculation environment is contextually relevant, not just a simple IF judgment. Therefore, while you can modify the displayed results through IF judgment, the real data will still participate in the calculation using the original values.
URL:
Power BI Switching between Logarithmic and Linear Scales - Mi4 Blog

I hope my suggestions give you good ideas, if you have any more questions, please clarify in a follow-up reply.
Best Regards,
Carson Jian

[Anonymous]

Hi,lbendlin,thanks for your concern about this issue.

Your answer is excellent!
And I would like to share some additional solutions below.
Hello,@F_Reh .I am glad to help you.
I think lbendlin's suggestion is a very good one, and I've created a test case of his suggestion below.
Logarithmic scales can effectively display data with a wide range of values, even if there are very large and very small values in the data, they can be clearly displayed.
Aggregated data with very large differences are displayed in the same visual (especially line/bar charts), and this option can be turned on to better analyze the data.

This is my test data:
DateDailySales

1/1/2024	10000
1/2/2024	15000
1/3/2024	12000
1/4/2024	600
1/5/2024	640
1/6/2024	487
1/7/2024	456

If you find this suggestion helpful, you can mark lbendlin's suggestion as a solution, which helps other users to quickly find a suitable solution.

I hope my suggestions give you good ideas, if you have any more questions, please clarify in a follow-up reply.
Best Regards,
Carson Jian

[lbendlin]

Consider setting the Y axis to logarithmic.