Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.
I have data column as "Sale State". In the visualize I want to sort
- Qualify 10% = 6
- Develop 20% = 5
- Solution 40% = 4
- Proof 60% = 3
- Close 80% = 2
- Invoice 100% = 1
- Lost 0% = 7
I create custom colum as "Sale State Index" and sort "Sale State" from "Sale State Index" but the Power BI show error "Filed to save modifications to the server. Error returned: A circular dependency was detected"
Please help me fix this error.
Solved! Go to Solution.
Hi @Settha
That error is because those the Sale State Index is related to Sale State, Try to add the Sale State Index column in Power Query rather than DAX.
Or create a table with dax by using ADDCOLUMN and VALUES([Sale State]) dax functions then relate a new table with the main table, and use Sale State column from a new table in your visuals.
If this post helps, please consider accepting it as the solution to help the other members find it more quickly.
Appreciate your Kudos!!
LinkedIn: www.linkedin.com/in/vahid-dm/
Hi @Settha
That error is because those the Sale State Index is related to Sale State, Try to add the Sale State Index column in Power Query rather than DAX.
Or create a table with dax by using ADDCOLUMN and VALUES([Sale State]) dax functions then relate a new table with the main table, and use Sale State column from a new table in your visuals.
If this post helps, please consider accepting it as the solution to help the other members find it more quickly.
Appreciate your Kudos!!
LinkedIn: www.linkedin.com/in/vahid-dm/
Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City
Check out the April 2024 Power BI update to learn about new features.
User | Count |
---|---|
47 | |
24 | |
20 | |
15 | |
13 |
User | Count |
---|---|
51 | |
46 | |
39 | |
19 | |
19 |