Power BI is turning 10! Tune in for a special live episode on July 24 with behind-the-scenes stories, product evolution highlights, and a sneak peek at what’s in store for the future.
Save the dateJoin us for an expert-led overview of the tools and concepts you'll need to become a Certified Power BI Data Analyst and pass exam PL-300. Register now.
Hi,
I am fairly new to Power-BI (previous Tableau and Qlik user), I wanted to do something that I thought was basic but I can't figure it out.
-I have a table with in which each row has an integer (let's say sales value). I want to categorize each line based on a parameter value, to define if they are over or under this value.
I created a column comparing the parameter but its content does not change when the parameter value is changed (I read that column are not recalculated during runtime). How can I make it work and have dynamic column but at row level (not aggregated measure) as I need this as a dimension in chart and to filter my data.
I made a dummy example below to synthetize my issue, any help would be appreciated !
Hi, sure, my actual use case can be sumed up with this sample data, then I can extrapolate :
Order;value
Order1;23
Order2;45
Order3;12
Order4;34
(sorry, the forum does not let me use tables for some reason, I get an "invalid HTML" error)
I also created a simple measure:
Orders = count('Table'[Order])
And a parameter :
Anomaly threeshold = GENERATESERIES(0, 50, 1)
I managed to do this in a table by using a measure :
Profitable order? = SELECTEDVALUE('Table'[Sales value])>'Anomaly threeshold'[Anomaly threeshold Value]
But I would also be able to uses this as a column for these use cases
-Use as a filter (ex: show a table with only the orders below/above this dynamically set value)
-Use as a color legend in a pie or bar chart with the repartition of my orders (below or above this value)
But I am not sure this is doable.
Can you add sample tables (in format that can be copied to PowerBI) from your model with anonymised data? Like this (just copy and paste into the post window).
Column1 | Column2 |
A | 1 |
B | 2.5 |
For this to be dynamic you will need to use a measure, iterator functions can calculate per row before aggregation, so it should be achievable - I should be able to give an example if you share your model
User | Count |
---|---|
14 | |
9 | |
7 | |
7 | |
6 |
User | Count |
---|---|
21 | |
11 | |
10 | |
10 | |
8 |