DAX Expression to create dynamic Index column to show all categorical values without scrollbar

[datpbi_newbie]

Hi Community, Good Evening. I have a requirement to show all the values for a categorical column without a scrollbar.

I created my chart with dimensions that had 370+ distinct values and DAX measure and got the below chart. But my business users want to see all the values without scroll bar.

To meet my requirements, I need a dynamic DAX column that holds an index value that can be used in the X-Axis as continuous. But how to write DAX to get such a dynamic index column to change with your selections. 

Dimension: Station Name

Measure: Actual Travel Time / Total Time

I have separate facts in the model and too many dimensions as filters in the page.

Thanks

[v-yetao1-msft · Accepted solution]

Hi @datpbi_newbie 

Maybe you can refer to field parameter . Field parameters allow users to dynamically change the measures or dimensions being analyzed within a report.

Let report readers use field parameters to change visuals (preview) - Power BI | Microsoft Docs 

Best Regards,
Community Support Team _ Ailsa Tao
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

[datpbi_newbie]

Hi Community, my requirement is to remove the Scroll Bar for the Categorical Column (Station Name) and show all the values.

I have some experience with other tools and its had much more options to control the scroll bar and there is no option available for Power BI to customize the scroll bar for the categorical columns.

So I trying to create a dynamic column ( I can't use the Measure in the x-axis or sort by column) to create a number column to accomplish this.

Any thoughts?

[amitchandak]

@datpbi_newbie , You can get a continuous axis for the Number and date field only

[datpbi_newbie]

Yes we can create continuous on the number and date field only.

So I am looking to create a dynamic Index number column for my string Station_Name column and I use Tool Tip to show the Station Name.