Conditional formatting on data type in chart

[Anonymous]

Hello everybody!

In my report I have a line chart which shows values that are dependent on which category you choose in a filter. However the values are always shown in one format, based on the data type. Is there a way to format some values (dependent on which category you choose) as a time and others as decimal?

Data example:

ID	Employee	Date	Metric	Value
1	John	01/01/2020	SALES_VALUE	1200
2	Peter	01/01/2020	WORK_TIME	01:37:00
3	Peter	01/01/2020	SALES_PERCENT	25%

I expect to get a line graph, where the manager could choose one metric, and this metric would appear with the correct format.

Is there any way to do this without splitting into different columns and formatting each?

Thanks!

[amitchandak]

@Anonymous , When you change measures inside a measure then formatting is an issue. Unless you pre-format them. Bookmark can replace chart and allow you to do

For slicer way refer: https://community.powerbi.com/t5/Desktop/Slicer-MTD-QTD-YTD-to-filter-dates-using-the-slicer/td-p/500115

for bookmark refer : https://radacad.com/bookmarks-and-buttons-making-power-bi-charts-even-more-interactive

Please Watch/Like/Share My webinar on Time Intelligence: https://community.powerbi.com/t5/Webinars-and-Video-Gallery/PowerBI-Time-Intelligence-Calendar-WTD-YTD-LYTD-Week-Over-Week/m-p/1051626#M184
My Youtube Tips at: https://www.youtube.com/playlist?list=PLPaNVDMhUXGYrm5rm6ME6rjzKGSvT9Jmy

Appreciate your Kudos.

[Greg_Deckler]

If returning text is OK then you can use FORMAT.

[Anonymous]

Hello! 

@Greg_Deckler 

Well, I guess not, because the graph will also feature a daily average per metric. Is there some way to do math operations if returns text? 

[Greg_Deckler]

Hard to say without more information @Anonymous . But you can do the math and just return the correct format at the end. Should work for totals as well. So within the measure you could check for the total row/column using something like HASONEVALUE and if it is a total row, do an AVERAGEX and then FORMAT.

[Anonymous]

@Greg_Deckler  Hello!

I've created a exemple project, can you take a look? There is a line graph with metric x time, and I filter it by metric.

https://drive.google.com/file/d/1IZRugbtavASNUdR-12XVrQjRix0sYJ2b/view?usp=sharing

[v-deddai1-msft]

Hi @Anonymous ,

It can't be achieved in one table to dynamic change data type based on slicer in one chart . You can refer to the  similar post : https://community.powerbi.com/t5/Desktop/Need-to-change-symbol-format-based-on-slicer-selection/td-p/1030056

As a workaround, you should divided them into three tables and use bookmark to achieve your requirement.

Best Regards,

Dedmon Dai

[Anonymous]

Hi @v-deddai1-msft could you elaborate on that? Would I need to create 3 separated visuals?

[v-deddai1-msft]

Hi @Anonymous ,

Yes, you need to create three visuals for it. Please refer to the simliar post: https://community.powerbi.com/t5/Desktop/Dynamic-grouping-based-on-slider-selections/td-p/1003423

Best Regards,

Dedmon Dai