The ultimate Fabric, Power BI, SQL, and AI community-led learning event. Save €200 with code FABCOMM.
Get registeredCompete to become Power BI Data Viz World Champion! First round ends August 18th. Get started.
Hi,
I want to show the target rate of sales made by the staff and the store. I want to create a measure. can you help me.
Solved! Go to Solution.
Hi @Anonymous
Hi @Anonymous
First, to implement the state of your line chart, you need a date column. Secondly, what does the line of store in your picture represent ? I create a sample , you can refer to .
Best Regards,
Community Support Team _ Ailsa Tao
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
Hi @Anonymous
Hi @Anonymous
First, to implement the state of your line chart, you need a date column. Secondly, what does the line of store in your picture represent ? I create a sample , you can refer to .
Best Regards,
Community Support Team _ Ailsa Tao
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
Thank you for your answer.
I'm sorry I couldn't express what I wanted to do.
I want to show the sales of the store and staff in a graph according to their quotas
Are you wanting to just divide [persontarget] with [storeTarget] to get a percentage?
DIVIDE(SELECTEDVALUE('Hedefler'[person Target]),SELECTEDVALUE('Hedefler'[Store target]))
User | Count |
---|---|
25 | |
10 | |
8 | |
6 | |
5 |
User | Count |
---|---|
31 | |
11 | |
10 | |
10 | |
9 |