cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
mws5872 Regular Visitor
Regular Visitor

Re: Switch X Axis column through a slicer filter

my bad -- its not dynamic labelings its using dynamic legend. so one graph could esentially replace many graphs if you get my drift. It would allow for massive reuse.

 

jdugre Frequent Visitor
Frequent Visitor

Re: Switch X Axis column through a slicer filter

Excellent solution @OwenAuger, thanks! Just a question, how do you use the order column in your visuals afterwards?

Super User
Super User

Re: Switch X Axis column through a slicer filter

Hi @jdugre

 

Are you asking about the Time Value Order column in my sample pbix file?

 

That column is used as the sort-by column for Time Value Text. Since Time Value Text contains a mixture of granularities (Date, DateTime, Month and Year in my case), it is impossible to sort this column based on its own values.

 

So Time Value Order is not directly used in any visuals, but set as the sort-by column for Time Value Text in Modeling = > Sort by Column. I also hid it in report view as the end user has no use for it.

 

Regards,

Owen



Did I answer your question? Mark my post as a solution!

Proud to be a Datanaut!




Highlighted
jdugre Frequent Visitor
Frequent Visitor

Re: Switch X Axis column through a slicer filter

It's the Modeling -> Sort by column, thanks!