Fabric is Generally Available. Browse Fabric Presentations. Work towards your Fabric certification with the Cloud Skills Challenge.
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 @THENNA_41,
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
HI @THENNA_41,
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
Check out the November 2023 Power BI update to learn about new features.
Read the latest Fabric Community announcements, including updates on Power BI, Synapse, Data Factory and Data Activator.