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?

OwenAuger Super Contributor
Super Contributor

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!

Helpful resources

Announcements
Community News & Announcements

Community News & Announcements

Get your latest community news and announcements.

Summit North America

Power Platform Summit North America

Register by September 5 to save $200

Virtual Launch Event

Microsoft Business Applications Virtual Launch Event

Watch the event on demand for an in-depth look at the new innovations across Dynamics 365 and the Microsoft Power Platform.

MBAS Gallery

Watch Sessions On Demand!

Continue your learning in our online communities.

Users Online
Currently online: 216 members 2,540 guests
Please welcome our newest community members: