how to create dynamic format that isnt in text

Anonymous · ‎06-04-2024

hello everyone,

i create a field paramter and a measure that uses switch to set each order to its respective measure

when i put this measure in a chart, i get the same format which is general, if i use the format option, i will end up with string text so the measure wont work in a line chart.

i know i can use directly the field paramter but i have my reasons to use a measure.

how can i make it dynamic?

parry2k · ‎06-05-2024

@Anonymous so what is the question or issue?

Subscribe to the @PowerBIHowTo YT channel for an upcoming video on List and Record functions in Power Query!!

Learn Power BI and Fabric - subscribe to our YT channel - Click here: @PowerBIHowTo

If my solution proved useful, I'd be delighted to receive Kudos. When you put effort into asking a question, it's equally thoughtful to acknowledge and give Kudos to the individual who helped you solve the problem. It's a small gesture that shows appreciation and encouragement! ❤

Did I answer your question? Mark my post as a solution. Proud to be a Super User! Appreciate your Kudos 🙂
Feel free to email me with any of your BI needs.

Anonymous · ‎06-06-2024

@parry2k , if you open the link i shared yesterday, it will take you to my question of how to filter measure values from field paramter, which doesnt work becasue only the paramter name gets filtered not values. so my work around was to make a new measure that uses switch to acheive my goal, however, they are the same format "general" and i want to make it dynamic

Anonymous · ‎06-10-2024

Hi @parry2k ,thanks for your quick reply, I'll add more.

Hi @Anonymous ,

The Table data is shown below:

You can set the type of the column to 'Text', and then convert it to the type you need through functions such as 'Value', 'DateValue', 'TimeValue', 'Int', 'Round', etc.

VALUE function (DAX) - DAX | Microsoft Learn

DATEVALUE function (DAX) - DAX | Microsoft Learn

TIMEVALUE function (DAX) - DAX | Microsoft Learn

ROUND function (DAX) - DAX | Microsoft Learn

Best Regards,
Wenbin Zhou
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

parry2k · ‎06-04-2024

@Anonymous not really clear what you are trying to achieve, let's say you have two measure

sales (format currency)

% sales (format percent)

and you added these measures in the field parameter, and now using this field parameter in the value section of the line chart, so when you select a value in the slicer that uses the field parameter then it will show the respective format in the line chart.

Not sure what you are looking for?

Subscribe to the @PowerBIHowTo YT channel for an upcoming video on List and Record functions in Power Query!!

Learn Power BI and Fabric - subscribe to our YT channel - Click here: @PowerBIHowTo

If my solution proved useful, I'd be delighted to receive Kudos. When you put effort into asking a question, it's equally thoughtful to acknowledge and give Kudos to the individual who helped you solve the problem. It's a small gesture that shows appreciation and encouragement! ❤

Did I answer your question? Mark my post as a solution. Proud to be a Super User! Appreciate your Kudos 🙂
Feel free to email me with any of your BI needs.