I am having one table where having formual based value at Country,state,district and village level. All are created as a hierarchy in tabular model, when I use this model in power bi and drag the value and country, it shows the sum of value (state+district+village) at country level, since all this value is formula based at every level so can not sum it. So how I can show the country level value when we drag country , when I drill , it should show the state and its corresponig value,not the sum of its child value.
2 Comments
- Need the option in power BI to show the raw data,not the summarisation in chart.This is mainly for value with datatype numeric. Even though when we set the value property as no summarisation in the model, it shows balnk when draging the value in chart.This is a very much required option.
- Status added:Needs Votes
