Forum Discussion
Build a dynamic histogram with dynamic variation
I have to do a histogram like this:
The rule to make this histogram to work is selecting two dates from two tables (the first is the copy from the another one) each, from two different slicers to take a variation (that will be explained at the next pictures). The histogram shows the number of occurences of variations distribuited by a key called "chavesig"(Referenced by 1.0 and 1.1 at the picture bellow). Here is the tables:
and the slicers:
The dates (2.1 and 2.0) and the measures (3.0 and 3.1) are necessary to made the variation where Variation(V) = Measure(from 3.0) - Measure(from 3.1).
The problem is that the Variation(V) is a measure(that solves other kpi's), not column, and the histogram, at the first picture, needs a column of dynamic variations between "chavesig" 1.0 at date 2.0 and "chavesig" 1.1 at date 2.1 to work.
Could anybody help?
Thank you all
5 Replies
Please see this post regarding How to Get Your Question Answered Quickly: https://community.powerbi.com/t5/Community-Blog/How-to-Get-Your-Question-Answered-Quickly/ba-p/38490
Anonymous , can you provide more information. make me @
Appreciate your Kudos.
Hi amitchandak , I've sent this other question today that is the exactly the same thing I want to do.
Could you help me? Here is the link:
Hi Anonymous ,
According your description, you want Variation(V) to be a dynamic column so that you can use it in the histogram? But you said Variation(V) is a measure calculated by measures and normally it can't be used as a column. So either you can share some sample data and expected out put to us, or this can't be done.
Best Regards,
Jay
Community Support Team _ Jay Wang
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
Hi Anonymous , I've sent this other question today that is the exactly the same thing I want to do.
Could you help me? Here is the link:
