Showing percentage and number values in same graph by filter

[oren]

Hi

not sure if its possible - but will try..

i have a table when in one column i have category and in the other there are values - some of the category need to shows as percentage format same as dollars - 

means - i create a graph from the data when my filter is base on "Category" when i choose "%" i want to see the data in percentage and when it's $ it should be dollars -

attached is the picture with an example for DB

thanks

oren 

[v-yuta-msft]

@oren, 

Create a line chart and drag [country] to Axis, [category] to Legend, [value] to Values, create a slicer based on column [category] like below:

 

Regards,

Jimmy Tao

[oren]

Thank you but what i am looking for is when i choose "%" the format of the Y exit will be in persentage and when i choose $ the format will be dolars (or reguler number)

(as i mentioned. it is a little weird request )

thanks

[v-yuta-msft · Accepted solution]

@oren, 

I'm afraid this can't be achieve currently in power bi. As a workaround, you may create two pages, on each page create a visual(percent, dollar), then create two book marks on the two pages. For more details, you may refer to: 

https://docs.microsoft.com/en-us/power-bi/desktop-bookmarks.

Regards,

Jimmy Tao