Find everything you need to get certified on Fabric—skills challenges, live sessions, exam prep, role guidance, and more. Get started
Hi guys,
I am having difficulty in using the format function.
I have this simple table:
I am using the simple column chart to represent value based on the slicer selection.
This is the measure that i am using:
any suggestion would be really helpful.
Thanks
Solved! Go to Solution.
Please mark my post as solution, this will also help others.
Please give Kudos for support.
Marcus Wegener works as Full Stack Power BI Engineer at BI or DIE.
His mission is clear: "Get the most out of data, with Power BI."
twitter - LinkedIn - YouTube - website - podcast - Power BI Tutorials
@TaroGulati Try this but it will return as text because it has different return types like whole number and percentage value.
@Tahreem24 thanks for the suggestion. For table is not an issue. I am trying to represnt these values on line chart which doesn't support the text format of measure.
@TaroGulati , Format the first 2 also, This creates few options as numbers and few as %, that will not work
You can explore calculation group if you need a different format for measure slicer
tabular - Calculation groups
https://docs.microsoft.com/en-us/analysis-services/tabular-models/calculation-groups?view=asallprodu...
@amitchandak thanks for the suggestion. i believe with the help of calculation group, this would not work because that will also return a measure as text and graph doesn't accept the format text.
Hi @TaroGulati ,
Amit is right, take a look at the attached PBIX.
Marcus Wegener works as Full Stack Power BI Engineer at BI or DIE.
His mission is clear: "Get the most out of data, with Power BI."
twitter - LinkedIn - YouTube - website - podcast - Power BI Tutorials
@mwegener thanks for your suggestion.
I think problem is still there.
in your calculation item, you assigned values to each selection of slicer but it is still not showing the values in percentage with % sign on the axis.
i tried to modifiy but still doesn't give the desired result.
Thanks again for your efforts.
Hi @TaroGulati ,
for me, the axis changes depending on the selection.
Is your requirement different?
Marcus Wegener works as Full Stack Power BI Engineer at BI or DIE.
His mission is clear: "Get the most out of data, with Power BI."
twitter - LinkedIn - YouTube - website - podcast - Power BI Tutorials
@mwegener thank you very much.
it seems my power bi desktop is not updated with Feburary 2022 features. Last version is of Dec 2021. I guess for this reason i don't see the same results that you see.
Thank you again.
Please mark my post as solution, this will also help others.
Please give Kudos for support.
Marcus Wegener works as Full Stack Power BI Engineer at BI or DIE.
His mission is clear: "Get the most out of data, with Power BI."
twitter - LinkedIn - YouTube - website - podcast - Power BI Tutorials