cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
Highlighted
xiumi_hou Member
Member

How to use a filter to show bar chart (one whole number one is a percentage)

Dear all, 

 

I have below bar chart.

lalala.JPG

 

All the indicator in the filter is a whole number. Now I want to add a indicator "percentage of missing/Cancel Session", my choice is either add to this graph or add it as a new indicator in the drop down filter. However, since it is a percentage, which is different from the other data type, because the field I put for the drop down filter is a combination of measres as below. Any suggestion? Thanks

Current Month_Session = SWITCH(
                            MIN('Measure Filter - Session'[Number]) ,
                            --------------------------------------
                            1,[Count_Sessions_Scheduled],
8,[Scheduled_without_cancelled_24hrs],
                            2,[Count_Held_Sessions],
                            3,[Count_A1_Assessment_Held],
                            6,[Count_Sessions_Cancel/Missing],
9,[Count_Sessions_Cancel_outside 24],
10,[Count_Percentage_Missing/Cancelled]
                            )
6 REPLIES 6
xiumi_hou Member
Member

Re: How to use a filter to show bar chart (one whole number one is a percentage)

UP

Community Support Team
Community Support Team

Re: How to use a filter to show bar chart (one whole number one is a percentage)

Hi xiumi_hou, 

I am not clear  about your requirement, if possible, could you please explain "However, since it is a percentage, which is different from the other data type, because the field I put for the drop down filter is a combination of measres as below. " and your expression to me? Or you could imform me your sample data and expected output. Then I will help you more correctly.

Best Regards,
Zoe Zhi

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

 

xiumi_hou Member
Member

Re: How to use a filter to show bar chart (one whole number one is a percentage)

@dax  Hi thanks for answering. My question is my filter(on the right corner) is a combination of different measures. It seems impossible to add a percentage measure to the bar chart because all other measures are integar

Community Support Team
Community Support Team

Re: How to use a filter to show bar chart (one whole number one is a percentage)

Hi xiumi_hou,

You said that you want to add a percentage measure in filter, what is the logic of the percentage measure? And as you mentioned above,  the value are all int, so I am not clear about the percentage measure's meaning. If possible, could you please explain me in details?

Best Regards,
Zoe Zhi

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

xiumi_hou Member
Member

Re: How to use a filter to show bar chart (one whole number one is a percentage)

@dax  Hi Thanks for answering. My question is , I want to use a measure (switch) to show some different indicators. Should I make the measure type as whole number of percentage? Since 6/7 of the measure format is integar and just one indicator format is percentage. But I can only use one graph with the switch measure to show. What data format should I put? I do not want 11%  to show as 0.11. Thank you so much

xiumi_hou Member
Member

Re: How to use a filter to show bar chart (one whole number one is a percentage)

UP

Helpful resources

Announcements
New Ranks and Rank Icons in 2020

New Ranks and Rank Icons in 2020

Read the announcement for more information!

New Kudos Given Badges Coming

New Kudos Given Badges Coming

We're rolling out new Kudos Given badges. Find out how many Kudos you've given.

November 2019 Community Highlights

November 2019 Community Highlights

Get an overview of the events and great community content from November.

Power Platform World Tour

Power Platform World Tour

Find out where you can attend!

Top Solution Authors
Top Kudoed Authors (Last 30 Days)