Forum Discussion
Turn on Format / Measure option
Hei,
How can I turn on this option in Power BI desktop
Thank you!
Hi HaiVN ,
there are at least two options to do that for a single measure:
- Choose "Dynamic" as Format from the Formatting Ribbon in Report-View
- Switch to Model-View, select a measure and choose "Dynamic" as Format from the Formatting section on Properties Pane
To see the "Format" dropdown menu shown in your screenshot, follow these steps:
Select the Measure: Click on the specific measure in the Data pane that you want to format.
Navigate to Measure Tools: Go to the Measure tools tab in the top ribbon.
Change Format to Dynamic: In the Formatting section, click the Format dropdown and select Dynamic at the very bottom.
Access the Format Script: Once "Dynamic" is selected, a new dropdown will appear to the left of the DAX formula bar. Switch this from Measure to Format to write your dynamic formatting logic.
3 Replies
- Hans-Georg_PulsSuper User
Hi HaiVN ,
there are at least two options to do that for a single measure:
- Choose "Dynamic" as Format from the Formatting Ribbon in Report-View
- Switch to Model-View, select a measure and choose "Dynamic" as Format from the Formatting section on Properties Pane
- Anand24Super User
- cengizhanarslanSuper User
To see the "Format" dropdown menu shown in your screenshot, follow these steps:
Select the Measure: Click on the specific measure in the Data pane that you want to format.
Navigate to Measure Tools: Go to the Measure tools tab in the top ribbon.
Change Format to Dynamic: In the Formatting section, click the Format dropdown and select Dynamic at the very bottom.
Access the Format Script: Once "Dynamic" is selected, a new dropdown will appear to the left of the DAX formula bar. Switch this from Measure to Format to write your dynamic formatting logic.