Specific Rows to Have Different Data Type

Question

Hi!&nbsp;&nbsp;I was assigned to make a simple table in PBI showing the values provided by the department. Here is a sample layout of the raw data.&nbsp;KEI/KPITypeSegmentJan-21Feb-21Mar-21Apr-21May-21Jun-21Jul-21Aug-21Sep-21Oct-21Nov-21Dec-21KPI1BulkBuilders100%100%100%100%&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;KPI1BulkDistributor100%100%100%100%&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;KPI1BulkIndustrial100%100%100%100%&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;KPI1BagBuilders100%99%100%99%&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;KPI1BagDistributor100%99%99%97%&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;KPI1BagIndustrial95%96%99%79%&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;KPI2BulkBuilders99%99%100%99%&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;KPI2BulkDistributor100%100%100%100%&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;KPI2BulkIndustrial99%99%100%100%&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;KPI2BagBuilders97%93%96%88%&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;KPI2BagDistributor95%95%96%87%&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;KPI2BagIndustrial95%99%95%97%&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;KPI3BulkAll3893108116&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;KPI3BulkAll9431&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;KPI3BagAll785704784779&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;KPI3BagAll7659449&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;As you can see, the numbers are mostly presented in %&nbsp;except for the KPI3 in which it should be presented in absolute numbers.&nbsp;In my inital process, I used 'unpivoted' and so all values are now in one column and I added a column to have a date column.Here is my output. My question is that is there a way for these values (highlighted in yellow) to show as absolute while the rest are in percentages?&nbsp;

jihwan_kim · Accepted Answer

Hi,&nbsp;newgirl&nbsp;Please check the below picture and the sample pbix file's link down below.I tried to create a sample based on the explanation.There are many ways to achieve this, but I suggest two ways like below.&nbsp;&nbsp;All measures are in the sample pbix file.&nbsp;https://www.dropbox.com/s/tdnfq3fk307d5nc/newgirl.pbix?dl=0&nbsp;&nbsp;&nbsp;Hi, My name is Jihwan Kim. &nbsp;If this post helps, then please consider accept it as the solution to help other members find it faster, and give a big thumbs up. &nbsp;Linkedin: linkedin.com/in/jihwankim1975/Twitter: twitter.com/Jihwan_JHKIM

Forum Discussion

Specific Rows to Have Different Data Type

2 Replies

Related content

Formatting specific row headers/row info

Power BI Scheduled Refresh – Different Timings for Specific Days

Adding comments to specific row in table visual

Difference between two rows

Table - space between specific rows

KEI/KPI	Type	Segment	Jan-21	Feb-21	Mar-21	Apr-21	May-21	Jun-21	Jul-21	Aug-21	Sep-21	Oct-21	Nov-21	Dec-21
KPI1	Bulk	Builders	100%	100%	100%	100%
KPI1	Bulk	Distributor	100%	100%	100%	100%
KPI1	Bulk	Industrial	100%	100%	100%	100%
KPI1	Bag	Builders	100%	99%	100%	99%
KPI1	Bag	Distributor	100%	99%	99%	97%
KPI1	Bag	Industrial	95%	96%	99%	79%
KPI2	Bulk	Builders	99%	99%	100%	99%
KPI2	Bulk	Distributor	100%	100%	100%	100%
KPI2	Bulk	Industrial	99%	99%	100%	100%
KPI2	Bag	Builders	97%	93%	96%	88%
KPI2	Bag	Distributor	95%	95%	96%	87%
KPI2	Bag	Industrial	95%	99%	95%	97%
KPI3	Bulk	All	38	93	108	116
KPI3	Bulk	All	9	4	3	1
KPI3	Bag	All	785	704	784	779
KPI3	Bag	All	76	59	44	9