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've been trying to add automatic column with py script, but without a success. So the idea is to lets say i have a table like below:
And the idea is to create a additional column which tells us a current situation of A or B value over time, so basically something like this: ( let's say that 7-th month data is updated)
Did anyone took similar approach to something like above? Looking for a suggestions & approach ideas or some solutions to problem above. A & B columns could also be like A (as value) and B as value category.
Thanks in advance!!
See if dynamic commentary in Power BI can meet your needs:
https://zebrabi.com/dynamic-commentary-power-bi/
https://blog.enterprisedna.co/adding-commentary-to-your-reports-in-a-dynamic-way/
You could do something like this with a measure incorporating a bunch of if/then logic specifying what you want to say in any conceivable situation but that seems pretty painful to write and not nearly as useful as showing a visual instead.
Obviously, but in my case there is a need to have tooltip/comments in addition to graph. My idea was to loop through dates and output value progression over time but as mentioned above - ended up without success.
Nested ifs are painful - i agree, but i consider it as last resort.
Thanks for your reply!
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 |
---|---|
16 | |
2 | |
2 | |
1 | |
1 |