The ultimate Microsoft Fabric, Power BI, Azure AI, and SQL learning event! Join us in Stockholm, Sweden from September 24-27, 2024.
2-for-1 sale on June 20 only!
Find everything you need to get certified on Fabric—skills challenges, live sessions, exam prep, role guidance, and more. Get started
Hello everybody!
I have a query on my BI wich contains the columns:
Name of owner Error Situation
Paul 1,0%
Maria 5,4%
Laura 2,1%
Pedro 1,4%
Louis 0,6%
This column "Situation" is a condicional column that tells me if this error is "OK" or "NOT OK". >>> If(Error>X; "Not OK"; "OK")
But sometimes this X (acceptable error) is 5%, sometimes is 4%, sometimes is 3%, sometimes is 2% and sometimes is 1%.
So, i need to create a slicer with this values of X (5%, 4%, 3%, 2%, 1%), and when i click, for example, in 5%, my situation column tells me if the Error is OK or NOT OK.
Can somebody help me?
Solved! Go to Solution.
Hi @Camillanaep,
Please create your table ( I called mine Selection) and then create this measure in your main table (Pourcen):Pourc
Pourc = var Test = if(HASONEVALUE(Selection[Type]),MIN(Selection[Type]),BLANK()) return IF(MIN(Data[Error])>Test,"OK","NOT OK")
Check image below:
Ninter
Hi,
You have posted the same question here. I have posted my solutin at that link.
Hi @Camillanaep,
Please create your table ( I called mine Selection) and then create this measure in your main table (Pourcen):Pourc
Pourc = var Test = if(HASONEVALUE(Selection[Type]),MIN(Selection[Type]),BLANK()) return IF(MIN(Data[Error])>Test,"OK","NOT OK")
Check image below:
Ninter
But now, as it is a measure, i'm not able to create a graph with my results of "Pourc". Do you have any idea of how can i use this new information to create a graph? (Like a pizza chart with "Count of Pourc", that changes when i change my filter of pourcentage)
Thank you!
Hi,
If my soltion helped, please mark it as Answer.
Ok Ashish, i will mark it as an answer.
I just have one more question, do you have any ideia of how can i transform this measure that you create into a column, so that i can create charts with this info?
Thank you!
Hi,
Thank you. Why can you not create a chart with the calculated field formula?
I can't because it is a measure. I need it to be a column to use on charts.
Join the community in Stockholm for expert Microsoft Fabric learning including a very exciting keynote from Arun Ulag, Corporate Vice President, Azure Data.
Check out the June 2024 Power BI update to learn about new features.
User | Count |
---|---|
102 | |
97 | |
80 | |
62 | |
57 |
User | Count |
---|---|
264 | |
120 | |
115 | |
83 | |
70 |