topic DAX Expression to create dynamic Index column to show all categorical values without scrollbar in DAX Commands and Tips

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

datpbi_newbie — Thu, 21 Jul 2022 01:35:03 GMT

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

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

amitchandak — Thu, 21 Jul 2022 03:55:45 GMT

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

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

datpbi_newbie — Fri, 22 Jul 2022 15:52:04 GMT

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.

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

datpbi_newbie — Mon, 25 Jul 2022 02:13:53 GMT

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?

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

Anonymous — Wed, 27 Jul 2022 07:56:20 GMT

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.