Join us for an expert-led overview of the tools and concepts you'll need to pass exam PL-300. The first session starts on June 11th. See you there!
Get registeredPower BI is turning 10! Let’s celebrate together with dataviz contests, interactive sessions, and giveaways. Register now.
Hi Everyone ,
I have the data set like the below
Booking status Date
Confirmed April - 2022
Confirmed April - 2022
Not Confirmed April - 2022
Amended April - 2022
Amended April - 2022
Amended April - 2022
Confirmed April - 2022
Confirmed May - 2022
Not Confirmed May - 2022
Amended May - 2022
Amended May - 2022
Amended May - 2022
How to get seperate Month column wise total percentage ?
plese find the attached Screen shot
Solved! Go to Solution.
HI @Anonymous,
What fields that you used to design the chart? Can you please share some more detail about these?
How to Get Your Question Answered Quickly
You can also try to use the following measure formula if helps:
Overall Percent by status type=
DIVIDE (
CALCULATE (
COUNT ( Table[Booking status] ),
ALLSELECTED ( Table ),
VALUES ( Table[Date] ),
VALUES ( Table[Booking status] )
),
CALCULATE (
COUNT ( Table[Booking status] ),
ALLSELECTED ( Table ),
VALUES ( Table[Booking status] )
)
)
Regards,
Xiaoxin Sheng
@Anonymous Thank you so much its working
HI @Anonymous,
What fields that you used to design the chart? Can you please share some more detail about these?
How to Get Your Question Answered Quickly
You can also try to use the following measure formula if helps:
Overall Percent by status type=
DIVIDE (
CALCULATE (
COUNT ( Table[Booking status] ),
ALLSELECTED ( Table ),
VALUES ( Table[Date] ),
VALUES ( Table[Booking status] )
),
CALCULATE (
COUNT ( Table[Booking status] ),
ALLSELECTED ( Table ),
VALUES ( Table[Booking status] )
)
)
Regards,
Xiaoxin Sheng
User | Count |
---|---|
16 | |
14 | |
13 | |
12 | |
11 |
User | Count |
---|---|
19 | |
15 | |
15 | |
11 | |
10 |