Continuous x-axis issue

[Tasos]

Hello,

I am trying to change the categorical type X-Axis into a continuous one but with no success.

I have created a Pareto Chart with the cumulative quantity per product, however, I cannot change the X-axis so it can fit all the products without scrolling.

Any Ideas on that?

Thanks

[dedelman_clng]

Check the datatype of your X-axis variable.  Only numbers and dates can be continuous.

Hope this helps

David

[Anonymous]

Hi. My x-axis are numeric, but I still could not convert Categorical to Continuous . Please advise 

[Tasos]

Thanks for the reply. However, it doesn't really help me on how to solve it. 

The product name is a combination of numbers and letters and therefore I cannot change the datatype into a number. 

Still, thanks for the info.

[Anonymous]

Hi @Tasos,

Could you please share your pbix file or sample data?

Best Regards,

Ravi

[Tasos]

Hello @Anonymous,

I hope that this link will help you.

Thank for your time!

[Anonymous]

Hi @Tasos,

Thanks for Sharing the Pbix File.

I have a concern that if you have data like combination of number and some text like (412079-NEW) then how you actually want in your visual. 

As @dedelman_clng discussed that it is only valid for Number and Date type data because they can be grouped. like

if i have data 1 to 10 then in categorical ways i can show 1,2,3,4,5,6,7,8,9,10 and in continous way like 1....5...10.

So if you have text then i have to group or set ranges for your data then might be possiblity to do that. So Again Could you please look into this and clarify my concern. .

Because i dont have any idea about your actual data and what exact output you want.

Best Regards,

Ravi

[Tasos]

Hello @Anonymous,

What I really need is a percentage as an X-Axis instead of the actual value (see example https://www.dropbox.com/s/yaj04exg04yu2bm/pareto%20example.xlsx?dl=0).

I can create a column having this value, however, by doing that I will lose the option of creating a dynamic output when slicers are applied. What could work though is to create a measure instead. However, as we cannot have measures as X-Axis, I assume that what I want is not feasible (at least at the moment).

I hope that what I am looking for is clearer now.

Thanks for your time!!

Tasos

[Anonymous]

Hi @Tasos,

I have gone through your file. I understand data and i think it is possible to implement column will be dynamic also. I have implented by taking your sample data of columns (i.e: Product,Rank and Sales). If you have rank column then it is very easy to do.

I am attaching pbix file of my solution.

https://drive.google.com/file/d/1X34vLe5rzn5vSPNH21-nzKTncFMH6Kox/view?usp=sharing

Hoping that i understood your requirement. 

Regrads,

Ravi

[Tasos]

Hi @Anonymous,

You have clearly understood my requirement and I appreciate your effort. 

However, there is an issue with your solution. The ranking is predefined and static. This means that if I apply filters (e.g. time period/country of sales/different type of products, e.t.c) the ranking will not be the same as the "total" one. 

If you can solve this, then you have fully solved my problem.

Thanks,

Tasos

[Anonymous]

Hi @Tasos,

Rank also you can calculate in power bi. Please follow these links

1. http://radacad.com/how-to-use-rankx-in-dax-part-1-of-3-calculated-columns

2. https://community.powerbi.com/t5/Desktop/Add-calculated-index-column-by-DAX/td-p/72448

3.https://stackoverflow.com/questions/45715963/creating-an-index-column-for-power-bi

Best Regards,

Ravi

[Anonymous]

On what logic you are gnerating that i cant understand clearly thtas why i gav you 3 links. Whatever your need you will find in these links.

I will suggest go with 3rd link first.

[Tasos]

Hello @Anonymous,

Thanks for your time and the links. I do appreciate your help.

However, it still doesn't give an answer to my problem (I guess I wasn't clear).  Please, see below,

The "total ranking" is a column based on total sales. The "ranking" is a measure.

As you can see, when no filters are applied, the two values are the same (as they should)

 

However, when filters are applied, then the "total ranking" is no longer accurate.

I am attaching again the PBI file, just in case you still have time to have a look

https://www.dropbox.com/s/31wfabuo26ropa5/pareto%20example.pbix?dl=0

Thanks again

[Anonymous]

Hi @Tasos,

I have modified pbix file with calculation of dynamic rank. Please have a look and if any concern kindly revert.

https://drive.google.com/file/d/13UnmuimhsKFiyjJ9FEZvbcBbqwyLxNQA/view?usp=sharing

Best Regards,

Ravi